Postgres Pro
Downloads
Home   >   mailing lists

Re: Moving postgres users accounts from one postgres 7.3 to postgres 8.0 - Mailing list pgsql-general

From Merlin Moncure
Subject Re: Moving postgres users accounts from one postgres 7.3 to postgres 8.0
Date
Msg-id b42b73150610180656g3cef6e1q5e2973aa68ab1de9@mail.gmail.com
Whole thread Raw
In response to Moving postgres users accounts from one postgres 7.3 to postgres 8.0  (Najib Abi Fadel <nabifadel@yahoo.com>)
List pgsql-general
Tree view 
On 10/18/06, Najib Abi Fadel <nabifadel@yahoo.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

pgsql-general by date:

Previous
From: "Merlin Moncure"
Date:
Subject: Re: increasing LIMIT with ORDER BY changes queryplan (7.4)
Next
From: Ron Johnson
Date:
Subject: Re: COPY FROM STDIN instead of INSERT