date:20060816

[ADMIN] two databases in one

2006-08-16 Thread Soulabaille Samantha

Hello, I'm working with a postgresql 7.4.7 I've got two databases with the same tables and schema on two different servers. I want to have only one database. So i would like to insert in the first database the data of the second database. I don't know how to do this because almost of the

Re: [ADMIN] two databases in one

2006-08-16 Thread Ben K.

I've got two databases with the same tables and schema on two different servers. I want to have only one database. So i would like to insert in the first database the data of the second database. I don't know how to do this because almost of the tables contains serial. It's for production

[ADMIN] Issue on Varchar Ordering

2006-08-16 Thread Erika Terahata Torres Prada e Silva - MPS

I´m with the same problem at order by at version 8.0.3 and O.S. Debian. I´ve tried with locale C, UTF8, encoding LATIN1, UNICODE and it did't work. From: Rodrigo Hjort rodrigo ( dot ) hjort ( at ) gmail ( dot ) com To: pgsql-hackers ( at ) postgresql ( dot ) org

Re: [ADMIN] two databases in one

2006-08-16 Thread Soulabaille Samantha

Thanks for your response. Indeed , the serials are used as foreign keys. We made a web site with a database. Then we duplicated the web site and the databse (without data, only schéma) for another server . The 2 databases were filled in the same time. Now someone would like to merge the 2

Re: [ADMIN] Restoring database question, part 2..

2006-08-16 Thread Jim Nasby

Please cc the list so others can help. Yes, those tables are per-database. -- Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED] Pervasive Software http://pervasive.comwork: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 -Original

Re: [ADMIN] two databases in one

2006-08-16 Thread Steve Crawford

Soulabaille Samantha wrote: Hello, I'm working with a postgresql 7.4.7 I've got two databases with the same tables and schema on two different servers. I want to have only one database. So i would like to insert in the first database the data of the second database. I don't know how to

Re: [ADMIN] Installing Postgres 8.1.4 on Linux RedHat

2006-08-16 Thread Amit Phatarphekar

Thanks All. There was an issue with my browser :(. What a waste of time for everyone. I was able to download the rpms and install them successfully. Thanks again for all your help. -Original Message- From: Devrim GUNDUZ [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 15, 2006

Re: [ADMIN] two databases in one

2006-08-16 Thread Guido Neitzer

On 16.08.2006, at 9:13 Uhr, Soulabaille Samantha wrote: I've got two databases with the same tables and schema on two different servers. I want to have only one database. Okay. I don't know how to do this because almost of the tables contains serial. And you have overlapping keys from

Re: [ADMIN] two databases in one

2006-08-16 Thread Mohan R

Please unsubscribe Regards R Mohan Blue Star Infotech Limited T : +91-22-66956969 ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not