On 29 May 2008, at 22:16, [EMAIL PROTECTED] wrote: > ... it > doesn't appear that my data from the defaults table was included in my > backup, therefore, it didn't get restored into my test database > > > [EMAIL PROTECTED]:~/data> pg_dump -a tatylee > tatyleebackup.sql > [EMAIL PROTECTED]:~/data> psql -d ledgersmbtest -f tatyleebackup.sql
I don't believe it's supposed to when using pg_dump. I don't use PostgreSQL for anything else, so I just use pg_dumpall for my daily backups. I believe that this dumps all databases stored in the postgres server. Stroller. ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users