Upgrade and Single User

From: Tom Browder <tom(dot)browder(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Upgrade and Single User
Date: 2012-09-19 16:33:11
Message-ID: CAFMGiz8knStJt7=LpNz5XNkszY5Jka2e_YsYwK_s1qij3KWogQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Jayadevan M 2012-09-21 09:35:31 pg_dump and pg_restore
Previous Message Kevin Grittner 2012-09-18 19:07:56 Re: Issue with PERFORM