Re: Moving postgres users accounts from one postgres 7.3 to postgres 8.0

From: "Merlin Moncure" <mmoncure(at)gmail(dot)com>
To: "Najib Abi Fadel" <nabifadel(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Moving postgres users accounts from one postgres 7.3 to postgres 8.0
Date: 2006-10-18 13:56:00
Message-ID: b42b73150610180656g3cef6e1q5e2973aa68ab1de9@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 10/18/06, Najib Abi Fadel <nabifadel(at)yahoo(dot)com> wrote:
>
> Hi,
>
> i need to move my postgres users with their passwords from one postgres
> version (7.3) to a newer one (8.1) .
> Is there an automatic way to do that without having to recreate the users
> with their passwords ??
>

did you try pg_dumpall?

merlin

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ron Johnson 2006-10-18 14:08:28 Re: COPY FROM STDIN instead of INSERT
Previous Message Merlin Moncure 2006-10-18 13:42:29 Re: increasing LIMIT with ORDER BY changes queryplan (7.4)