Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group