[Solved] Unable To Dump Postgresql Database

[mrty]

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.

[Krydos]

Please post the following information:

• Your cPanel username
  
• Your main domain
  
• The server that you are on
  

[mrty]

Sorry, have not been around for some days.

 

cPanel username: mrty

main domain: m.heliohost.org

server: Stevie

 

Thanks for looking into my issue.

[mrty]

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?

[Ice IT Support]

This support request is being escalated to our root admin.

[Krydos]

What database are you trying to backup?

[mrty]

I am trying to backup the database "mrty_ttrssp".

[Krydos]

Check out the file mrty_ttrssp.sql in your home directory. Let me know if it looks like it dumped properly.

[mrty]

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?

[Krydos]

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.

[mrty]

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.