Thread: moving database to production
Hi, How to move the database from devleopment to production. For example, the database is already in production and some of the tables required modifications. First those modification were implemented in develoment. The modified tables need to be moved to production from development,not the complete database. So how to move the selective tables in development database to production database. Thanks chava
On 28 Sep 2001, at 12:12, Srinivasa Rao Chava wrote: > Hi, > How to move the database from devleopment to production. > For example, the database is already in production and some of the > tables required modifications. First those modification were > implemented in develoment. The modified tables need to be moved to > production from development,not the complete database. So how to move > the selective tables in development database to production database. > Thanks chava pg_dump -t <new_table> <dev_db> |psql <prod_db> Mark
Thanks for your response. But I want to move the database objects owned by a particualr user. say there are 20 tables,and other database objects like functions, procedures etc owned by two different users. I want to move the database objects( tables, and other objects like procedures, sequences) owned by a particular user to production. If I use pg_dump with -t option, I can move the tables. But what about the other objects like sequences and procedures owned by a particualar user. In oracle, we can use export and import with owner=user name option to move the complete schema owned by a particualr user. How to do it ion pgsql. Thanks chava -- Srinivasa R Chava (Chava) <s.chava@wcom.com> Application Developer Corporate Intra/Internet Systems WORLDCOM - http://www.worldcom.com/ - NASDAQ:WCOM 500 Clinton Center Drive (Corporate Headquarters) Clinton, Mississippi (MS) USA 39056 (601)460-3122 / vnet4603122 / (800)844-1009 / FAX(601)460-8257
Thanks for your response. But I want to move the database objects owned by a particualr user. say there are 20 tables,and other database objects like functions, procedures etc owned by two different users. I want to move the database objects( tables, and other objects like procedures, sequences) owned by a particular user to production. If I use pg_dump with -t option, I can move the tables. But what about the other objects like sequences and procedures owned by a particualar user. In oracle, we can use export and import with owner=user name option to move the complete schema owned by a particualr user. How to do it in pgsql. Thanks chava > > Hi, > > How to move the database from devleopment to production. > > For example, the database is already in production and some of the > > tables required modifications. First those modification were > > implemented in develoment. The modified tables need to be moved to > > production from development,not the complete database. So how to move > > the selective tables in development database to production database. > > Thanks chava > > pg_dump -t <new_table> <dev_db> |psql <prod_db> > > Mark > > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org