pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedUser table porting
5+ messages / 5 participants
[nested] [flat]
* User table porting
@ 2009-03-10 17:13 Carol Walter <walterc@indiana.edu>
2009-03-10 17:23 ` Re: User table porting Kevin Kempter <kevink@consistentstate.com>
2009-03-10 17:31 ` Re: User table porting Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 2 replies; 5+ messages in thread
From: Carol Walter @ 2009-03-10 17:13 UTC (permalink / raw)
To: pgsql-admin
I want to recreate users with their passwords from one database
cluster on another database cluster. What would be the best way for
me to do this?
Thanks,
Carol
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: User table porting
2009-03-10 17:13 User table porting Carol Walter <walterc@indiana.edu>
@ 2009-03-10 17:23 ` Kevin Kempter <kevink@consistentstate.com>
2009-03-10 18:29 ` Re: User table porting Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>
1 sibling, 1 reply; 5+ messages in thread
From: Kevin Kempter @ 2009-03-10 17:23 UTC (permalink / raw)
To: pgsql-admin
On Tuesday 10 March 2009 11:13:54 Carol Walter wrote:
> I want to recreate users with their passwords from one database
> cluster on another database cluster. What would be the best way for
> me to do this?
>
> Thanks,
> Carol
from the "old" server run this (where <new_db_cluster> is the new server):
pg_dumpall -g | psql -h <new_db_cluster>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: User table porting
2009-03-10 17:13 User table porting Carol Walter <walterc@indiana.edu>
2009-03-10 17:23 ` Re: User table porting Kevin Kempter <kevink@consistentstate.com>
@ 2009-03-10 18:29 ` Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>
2009-03-10 19:33 ` Re: User table porting Scott Marlowe <scott.marlowe@gmail.com>
0 siblings, 1 reply; 5+ messages in thread
From: Jan-Peter Seifert @ 2009-03-10 18:29 UTC (permalink / raw)
To: Kevin Kempter <kevink@consistentstate.com>; +Cc: pgsql-admin
Hello,
Kevin Kempter wrote:
> On Tuesday 10 March 2009 11:13:54 Carol Walter wrote:
>> I want to recreate users with their passwords from one database
>> cluster on another database cluster. What would be the best way for
>> me to do this?
> from the "old" server run this (where <new_db_cluster> is the new server):
> pg_dumpall -g | psql -h <new_db_cluster>
Isn't it generally better to use the newer binaries from the target
server especially with psql?
I remember getting quite a few errors when restoring a pg_dumpall from
an 8.1 server, because the create user syntax in the dump file was obsolete.
You might need some more options for piping (-U etc.):
http://www.postgresql.org/docs/8.3/interactive/app-pg-dumpall.html
Peter
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: User table porting
2009-03-10 17:13 User table porting Carol Walter <walterc@indiana.edu>
2009-03-10 17:23 ` Re: User table porting Kevin Kempter <kevink@consistentstate.com>
2009-03-10 18:29 ` Re: User table porting Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>
@ 2009-03-10 19:33 ` Scott Marlowe <scott.marlowe@gmail.com>
0 siblings, 0 replies; 5+ messages in thread
From: Scott Marlowe @ 2009-03-10 19:33 UTC (permalink / raw)
To: Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>; +Cc: Kevin Kempter <kevink@consistentstate.com>; pgsql-admin
On Tue, Mar 10, 2009 at 12:29 PM, Jan-Peter Seifert
<Jan-Peter.Seifert@gmx.de> wrote:
>
> Isn't it generally better to use the newer binaries from the target
> server especially with psql?
Generally this is true.
> I remember getting quite a few errors when restoring a pg_dumpall from
> an 8.1 server, because the create user syntax in the dump file was obsolete.
> You might need some more options for piping (-U etc.):
But we're not really doing a pg_dumpall of everything, just he global
objects. Not sure if there's any issues with a later version versus a
newer version there. Probably best to use the newer pg_dumpall /
pg_dump than the older one though.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: User table porting
2009-03-10 17:13 User table porting Carol Walter <walterc@indiana.edu>
@ 2009-03-10 17:31 ` Tom Lane <tgl@sss.pgh.pa.us>
1 sibling, 0 replies; 5+ messages in thread
From: Tom Lane @ 2009-03-10 17:31 UTC (permalink / raw)
To: Carol Walter <walterc@indiana.edu>; +Cc: pgsql-admin
Carol Walter <walterc@indiana.edu> writes:
> I want to recreate users with their passwords from one database
> cluster on another database cluster. What would be the best way for
> me to do this?
See pg_dumpall with -g option.
regards, tom lane
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2009-03-10 19:33 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2009-03-10 17:13 User table porting Carol Walter <walterc@indiana.edu>
2009-03-10 17:23 ` Kevin Kempter <kevink@consistentstate.com>
2009-03-10 18:29 ` Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>
2009-03-10 19:33 ` Scott Marlowe <scott.marlowe@gmail.com>
2009-03-10 17:31 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox