PDA

View Full Version : cant back up database



loseallmymoney
04-26-2011, 03:52 AM
when i try to back up my database it tells me postgres installation folder could not be found

Sarek
04-26-2011, 04:28 AM
It happens on some configurations. Please use PGadmin backup feature instead.
Start - programs - postgresql - pgadminIII

unnamed
04-26-2011, 09:55 AM
It also happened to me

I used the pgadminIII backup

Now, I will transfer from one HD to another.

After that, how do I restore it?

Thanks!

Sarek
04-26-2011, 11:23 AM
For restore please use PGadmin too.
First create empty DB (in UTF encoding) there and then do right-click - restore (select right backup).

loseallmymoney
04-27-2011, 01:53 AM
C:/Program Files/PostgreSQL/9.0/bin\pg_dump.exe --host localhost --port 5433 --username "postgres" --format plain --verbose --file "D:\HEM manager.backup" \"To\"
pg_dump: [archiver (db)] connection to database ""To"" failed: FATAL: database ""To"" does not exist
pg_dump: *** aborted because of error

Process returned exit code 1.

is what comes when i do that

Sarek
04-27-2011, 06:02 AM
do you really have database named "To"?
Example of working command:
"C:\Program Files\PostgreSQL\9.0\bin\pg_dump.exe" -i -h localhost -p 5432 -U postgres -F c -b -v -f "F:\backdb\test.back" "hmtttest"


"C:/Program Files/PostgreSQL/9.0/bin/pg_restore.exe" --host localhost --port 5432 --username postgres --dbname "newtest" --clean --verbose "F:\backdb\test.back"
but you need to create empty DB "newtest" before

unnamed
05-05-2011, 08:37 AM
Using pgAdmin does not backup my config file and HM setup, just the database.

I really need this. How can I do?

Thanks!!!

loseallmymoney
05-05-2011, 09:07 AM
yes i really have To, the rest of your post is chinese to me

fozzy71
05-05-2011, 10:44 AM
C:/Program Files/PostgreSQL/9.0/bin\pg_dump.exe .....

Are you using the exact same version of postgresql to restore the file as you used to create it? If your old DB was 8.4 you should use 8.4 again.


Using pgAdmin does not backup my config file and HM setup, just the database.

I really need this. How can I do?

Thanks!!!

http://faq.holdemmanager.com/questions/99/Reinstalling+HEM+without+Losing+Preferences+

unnamed
05-05-2011, 11:26 AM
Thanks a lot fozzy!