Re: trying to back up a database

Adam Haberlach wrote:
> 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.

pg_dump -d database >dump

should copy the database schema and all data records into dump.

> 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).

I don't know what you mean by the last bit. Are you saying that `man
pg_dumpall'
runs pg_dumpall?

pg_dumpall must be run by postgres, it may well have problems if you
are running it as an unprivileged user.

> This is with 7.0.2 -- should I upgrade or is this still an issue?

It's not an issue at all. You must be doing something weird!
If not, please say what platform you're on, and show your exact commands
and what output you're getting.

--
Oliver Elphick Oliver(dot)Elphick(at)lfix(dot)co(dot)uk
Isle of Wight http://www.lfix.co.uk/oliver
PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47 6B 7E 39 CC 56 E4 C1 47
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"Jesus saith unto him, I am the way, the truth, and the
life; no man cometh unto the Father, but by me."
John 14:6