Re: [ADMIN] How to add constraints without validating data.

2010-05-28 Thread Robert Voinea
Why don't you use a partition? Create another table that inherits from the table and add your new constraints to the new table. On Thursday 27 May 2010 19:32:33 Nilesh Govindarajan wrote: On Thu, May 27, 2010 at 9:49 PM, Iñigo Martinez Lasala imarti...@vectorsf.com wrote: Constraints are

Re: [ADMIN] About Context-switch storm problem

2010-05-28 Thread Iñigo Martinez Lasala
Hi, Yongwei We finally upgraded our database server to last PostgreSQL 8.2 available. Since 8.2 does not include any major change (8.3 does indeed a lot of them) we had no problem with this upgrade. And believe, our database was really complex. About 600 tables with 300 stored procedures, wide

[ADMIN] Oracle's Long data type equivalent data type in Postgresql ?

2010-05-28 Thread Ravi Katkar
Hi , What is the Oracle's Long data type equivalent data type in Postgresql ? Regards, Ravi katkar

Re: [ADMIN] Oracle's Long data type equivalent data type in Postgresql ?

2010-05-28 Thread Achilleas Mantzios
Στις Friday 28 May 2010 11:45:17 ο/η Ravi Katkar έγραψε: Hi , What is the Oracle's Long data type equivalent data type in Postgresql ? int8 i guess Regards, Ravi katkar -- Achilleas Mantzios -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make

[ADMIN] pginstaller policy?

2010-05-28 Thread Jan-Peter Seifert
Hello, I wonder whether pginstaller is still being maintained for 8.3 and 8.2, because there are no binaries for the current minor versions yet and because of this comment from January 10ths newsletter: --- In pgsql/doc/src/sgml/installation.sgml, update Windows

Re: [ADMIN] pginstaller policy?

2010-05-28 Thread Bruce Momjian
Jan-Peter Seifert wrote: Hello, I wonder whether pginstaller is still being maintained for 8.3 and 8.2, because there are no binaries for the current minor versions yet and because of this comment from January 10ths newsletter: --- In

[ADMIN] FW: Restore pg_dumpall

2010-05-28 Thread ALEXANDER JOSE
Perform a backup with the following command; pg_dumpall-Upostgres and record it in a file called respaldo.sql postgres in my instance I have 22 databases, I wondered if the above command I have supported all my databases and I use another command. Atentamente Alexander Angel Venezuela

Re: [ADMIN] pginstaller policy?

2010-05-28 Thread Marc G. Fournier
On Fri, 28 May 2010, Bruce Momjian wrote: I talked to Dave Page and it seems the pginstaller (non-bitRock) Win32 installers were _not_ moved from their beta holding area to the download section. They have just been moved and the URLs are now:

Re: [ADMIN] pginstaller policy?

2010-05-28 Thread Bruce Momjian
Marc G. Fournier wrote: On Fri, 28 May 2010, Bruce Momjian wrote: I talked to Dave Page and it seems the pginstaller (non-bitRock) Win32 installers were _not_ moved from their beta holding area to the download section. They have just been moved and the URLs are now:

Re: [ADMIN] pginstaller policy?

2010-05-28 Thread Dave Page
On Fri, May 28, 2010 at 6:56 PM, Bruce Momjian br...@momjian.us wrote: Marc G. Fournier wrote: On Fri, 28 May 2010, Bruce Momjian wrote: I talked to Dave Page and it seems the pginstaller (non-bitRock) Win32 installers were _not_ moved from their beta holding area to the download

Re: [ADMIN] Relation between RAM / shmmax / shmall / shared_buffers

2010-05-28 Thread Greg Smith
Balkrishna Sharma wrote: 1. Keeping the kernel parameter kernel.shmmax at 75% of RAM (i.e. at 3GB )kernel.shmmax = 3221225472 2. Keeping the kernel parameter shmall at the same value. Because shmall is measured in number of pages and each page on my linux is 4096 bytes, having kernel.shmall =