Postgres Pro
Downloads
Home   >   mailing lists

Upgrade and Single User - Mailing list pgsql-novice

From Tom Browder
Subject Upgrade and Single User
Date
Msg-id CAFMGiz8knStJt7=LpNz5XNkszY5Jka2e_YsYwK_s1qij3KWogQ@mail.gmail.com
Whole thread Raw
Responses Re: Upgrade and Single User  (Bartosz Dmytrak <bdmytrak@gmail.com>)
List pgsql-novice
Tree view 
I want to upgrade my existing installation and would like to ensure
the db is not modified until I get the new installation running.

Is there any way to restart into a single user mode so that a
pg_dumpall works as the superuser?  Or am I limited to a stop, fiddle
with pg_hba.conf, restart, pg_dumpall, etc.?

Thanks,

-Tom

pgsql-novice by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Issue with PERFORM
Next
From: Jayadevan M
Date:
Subject: pg_dump and pg_restore