Skip site navigation (1)
Skip section navigation (2)
My goal is to restore someone's (e.g. Jim's) database by the superuser to be owned by a new user (e.g. Bob). Jim and Bob connects using password and I (the superuser) do not know their passwords.
Is it possible to do pg_restore, connecting as the superuser, specifying --no-owner, but making so that all objects now be owned by the new user (e.g. Bob)? Or do I have to resort to other tricks (like doing ALTER OWNER later, or modifying pg_hba.conf temporarily so the superuser can connect as Jim without a password)?
Regards,
Dave
Peripheral Links
Header And Logo
|
Site Navigation
Restoring a database as another user
- From: "David Garamond" <davidgaramond(at)gmail(dot)com>
- To: pgsql-admin(at)postgresql(dot)org
- Subject: Restoring a database as another user
- Date: Fri, 28 Apr 2006 14:17:30 +0700
My goal is to restore someone's (e.g. Jim's) database by the superuser to be owned by a new user (e.g. Bob). Jim and Bob connects using password and I (the superuser) do not know their passwords.
Is it possible to do pg_restore, connecting as the superuser, specifying --no-owner, but making so that all objects now be owned by the new user (e.g. Bob)? Or do I have to resort to other tricks (like doing ALTER OWNER later, or modifying pg_hba.conf temporarily so the superuser can connect as Jim without a password)?
Regards,
Dave
- Follow-Ups:
- Re: Restoring a database as another user
- From: Tom Lane
- Re: Restoring a database as another user
- Prev by Date: Re: Orphan files
- Next by Date: Autovacuum probably not working?
- Previous by thread: connection refused 274D/10061
- Next by thread: Re: Restoring a database as another user
- Indexes: