Peter Eisentraut wrote:
>> > pg_dumpall must be run by postgres, it may well have problems if you
>> > are running it as an unprivileged user.
>
>Nope
Seeing that the unprivileged user may not have SELECT permission on
some of the tables, he ought to have problems!
--
Oliver Elphick
Adam Haberlach writes:
> Sorry--I mean that when I type "pg_dumpall -h, it connects", but I guess
> that is because it is a simple script.
Nobody ever said that '-h' prints a help screen.
> > pg_dumpall must be run by postgres, it may well have problems if you
> > are running it as an unp
On Wed, Jan 31, 2001 at 11:27:18PM +, Oliver Elphick wrote:
> 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
>
> s
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
