| From: | Jacob Atzen <jaa(at)interflow(dot)dk> |
|---|---|
| To: | Christopher Browne <cbbrowne(at)acm(dot)org> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Backing up multiple databases |
| Date: | 2005-06-17 13:40:07 |
| Message-ID: | 20050617134007.GB11639@interflow.dk |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, Jun 17, 2005 at 08:43:21AM -0400, Christopher Browne wrote:
> >> There is an option to pg_dumpall, -O, which makes it dump stuff
> >> without owners. See the following:
> > Ah yes, I should have told you that the server is running 7.4.5,
> > sorry. I will consider upgrading if there's no alternative way.
> That option did exist in 7.4, so you're not being steered terribly
> wrongly, although you may want to check the docs from v7.4 in case
> there are any other differences relevant to you.
It doesn't exist in pg_dumpall on 7.4.5:
% pg_dumpall -O
pg_dumpall: invalid option -- O
But I'll just use pg_dump where it does exist.
--
Thanks,
Jacob Atzen
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Fuhr | 2005-06-17 13:50:56 | Re: psql: FATAL: database "template1" is not currently accepting connections |
| Previous Message | Albert Vernon Smith | 2005-06-17 13:18:06 | query plan in pg7.4 vs 8.0.3 |