Re: Problems upgrading from 7.1.3

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: David Gilbert <dgilbert(at)velocet(dot)ca>
Cc: Geoffrey Wossum <geoffrey(at)pager(dot)net>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Problems upgrading from 7.1.3
Date: 2003-02-06 19:44:13
Message-ID: 14866.1044560653@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

David Gilbert <dgilbert(at)velocet(dot)ca> writes:
> I find that the whole database dumps do not have 'create user' and
> 'create group' commands.

Those are dumped by pg_dumpall, but not by pg_dump. Since users and
groups span all databases in an installation, it wouldn't be very useful
for pg_dump to include them in its (per-database) output.

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2003-02-06 19:47:10 Re: Failed to initialize lc_messages to ''
Previous Message Stephan Szabo 2003-02-06 19:33:37 Re: Indexes on Large Tables