By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,985 Members | 1,885 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,985 IT Pros & Developers. It's quick & easy.

How to edit oid of database?

P: 1
I want to create 2 databases in 2 server and these have only one OID. Example:

Server 1: database 'Test' with OID: 16384
Server 2: database 'Test' with OID: 16353

I want to edit OID of database Test on server 2 to 16384.
How to do that?

And how to create a database with fix OID??

(I have a problem when using replication with pgpool II, pgadmin cannot connect to new database because they have 2 different oids from 2 servers, please help!)

Thanks!
Jul 5 '10 #1
Share this Question
Share on Google+
1 Reply


Expert 100+
P: 700
I don't think edit OID it is a good idea, it is not 'supported' by postgres.
You probably can try to edit it ('postgres pg_catalog hacking' :)) but probably it may be not easy.
Why don't you backup the first database and use it to create the second one. If both clusters should be the same you can also just copy cluster where the first database is installed to the second server.
Jul 8 '10 #2

Post your reply

Sign in to post your reply or Sign up for a free account.