bibico
Last Activity: Jul 18 '08, 09:21 AM
Joined: Jul 12 '08
Location:
-
database backup to include circular dependencies
how could i include tables and types dependent to each other during backup. I am using postgresql 8.2. When doing the backup/restore on the same system, no problem - all is there and complete. However, i need to do the backup in another system, and the tables of the database restored have missing columns. I have read a dump program written in C from postgresql site. However, I am not sure how to run in in postgresql. I am new to postgresql, if you... -
I attached here the pics, maybe you could take a look at it :)
thanks :)
the left one is the source database and the right one is the database backup created in another computer but no Types exported and some columns are missing...... -
thanks, Ü
is there any setting that i have to check on at pgadmin before using the backup utility and doing the restore so everything would be included? Or, maybe, is there anything wrong with the process i did?Leave a comment:
-
when i open pg_hba from File menu pf pgadmin - it opens a window explorer asking which file, if i click on cancel, nothing is written inside. If i open the pg_hba.conf file from data directory of postgresql installation, this is what i have, excluding those lines with #.
host all all 127.0.0.1/32 md5
i think this is just for local host. what i have been trying to do is backup/transfer the database from one...Leave a comment:
-
i am having the same problem on doing a backup of a database from one computer to another, from postgresql to prostgresql though and not oracle. I got the same problem about the password being asked when using the command prompt. i was able to backup and restore using pgadmin but types were not exported/restored - so some columns are missing. Also where can i find a tutorial on pgadmin and prosgresql where i could operate on dummy database? Thanks....Leave a comment:
No activity results to display
Leave a comment: