mrty Posted October 1, 2013 Share Posted October 1, 2013 Hi, I am trying to dump a PostgreSQL database using phpPgAdmin available in cPanel. Sadly, no data is exported. The only output I get is: -- -- PostgreSQL database cluster dump -- \connect postgres \connect ###other user's database### It seems that the export script is trying to dump all databases available in alphabetical order. As it should be, this fails because of missing priviledges. Could you please look into this? Am I doing something wrong? Just trying to backup my data. Link to comment Share on other sites More sharing options...
Krydos Posted October 5, 2013 Share Posted October 5, 2013 Please post the following information:Your cPanel username Your main domain The server that you are on Link to comment Share on other sites More sharing options...
mrty Posted October 8, 2013 Author Share Posted October 8, 2013 Sorry, have not been around for some days. cPanel username: mrtymain domain: m.heliohost.orgserver: Stevie Thanks for looking into my issue. Link to comment Share on other sites More sharing options...
mrty Posted October 18, 2013 Author Share Posted October 18, 2013 Are you able to reproduce my problem? Just tried again, still not able to backup any data. Is there anything I can do to help resolving this problem? Link to comment Share on other sites More sharing options...
Ice IT Support Posted October 21, 2013 Share Posted October 21, 2013 This support request is being escalated to our root admin. Link to comment Share on other sites More sharing options...
Krydos Posted October 21, 2013 Share Posted October 21, 2013 What database are you trying to backup? Link to comment Share on other sites More sharing options...
mrty Posted October 21, 2013 Author Share Posted October 21, 2013 I am trying to backup the database "mrty_ttrssp". Link to comment Share on other sites More sharing options...
Krydos Posted October 21, 2013 Share Posted October 21, 2013 Check out the file mrty_ttrssp.sql in your home directory. Let me know if it looks like it dumped properly. Link to comment Share on other sites More sharing options...
mrty Posted October 22, 2013 Author Share Posted October 22, 2013 Check out the file mrty_ttrssp.sql in your home directory. Let me know if it looks like it dumped properly. Yes, thanks a lot, the dump looks perfectly allright. Have you been able to backup the database using end-user-accessible tools? Link to comment Share on other sites More sharing options...
Krydos Posted October 25, 2013 Share Posted October 25, 2013 The problem seems to be that one of my predecessors upgraded postgresql to a version unsupported by cpanel, and didn't upgrade the software that creates backups of databases. Try creating a backup of your database yourself with phppgadmin and let me know if it works now. Otherwise, at least I can keep manually creating postgresql database backups manually for anyone who needs it. Link to comment Share on other sites More sharing options...
mrty Posted October 28, 2013 Author Share Posted October 28, 2013 Try creating a backup of your database yourself with phppgadmin and let me know if it works now.Thank you very much, I am now able to dump the database using phpPgAdmin. Many thanks for your great support. Link to comment Share on other sites More sharing options...
Recommended Posts