I'm trying to back up a database, including the user records. If
I use pg_dump, I can get the table, but I cannot seem to be the user
information.
If I use pg_dumpall, it seems to have trouble connecting to various
databases (in fact, it attempts to connect even if I merely want the
help page).
This is with 7.0.2 -- should I upgrade or is this still an issue?
(I really just want a way to create a copy of a database, including
permissions and passwords, so I can make changes, test my interface
code, and then modify the original database. Is that so wrong?)
--
Adam Haberlach |A cat spends her life conflicted between a
adam@newsnipple.com |deep, passionate, and profound desire for
http://www.newsnipple.com |fish and an equally deep, passionate, and
'88 EX500 |profound desire to avoid getting wet.