[ADMIN] create foreign key without checking

2007-10-25 Thread Ewald Geschwinde
Is there a way to make inserts int the systemtables to create a foreign key without checks I have archive tables to put in the database - and then data will be inserted afterwards to that table I want to switch off foreign keys for the import and activate them after the import but without checking

[ADMIN] sending data with COPY SQL command, libpq and structure of SELECT resulting buffer

2007-10-25 Thread Adam Radlowski
I sent this message to INTERFACES, but there is no answer, maybe on ADMIN list somebody knows something about it... From the docs i understood, that with COPY SQL command we should use for synchr. sending: PQexec PQResultstatus returns PGRES_COPY_OUT PQputCopyData PQputCopy

Re: [ADMIN] Problem with PITR Past Particular WAL File

2007-10-25 Thread Craig McElroy
Tom: Thanks for your help on this. The trace details are as follows: Core was generated by `/usr/local/pgsql/bin/postgres -D /pgdata01/data'. Program terminated with signal 11, Segmentation fault. #0 0x080b8ee0 in entrySplitPage () #1 0x080baccf in ginInsertValue () #2 0x080b81b7 in gin_xl

Re: [ADMIN] Problem with PITR Past Particular WAL File

2007-10-25 Thread Alvaro Herrera
Craig McElroy wrote: > Tom: > Thanks for your help on this. The trace details are as follows: > > Core was generated by `/usr/local/pgsql/bin/postgres -D /pgdata01/data'. > Program terminated with signal 11, Segmentation fault. > > #0 0x080b8ee0 in entrySplitPage () > #1 0x080baccf in ginInser

Re: [ADMIN] Problem with PITR Past Particular WAL File

2007-10-25 Thread Craig McElroy
Alvaro: I just tried, but I only get "No symbol table info available." after each line of the trace. Cheers, -craig --- Craig A. McElroy Contegix Beyond Managed Hosting(r) for Your Enterprise On Oct 25, 2007, at 7:57 AM, Alvaro Herrera wrote: Craig McElroy wrote: Tom: Thanks for your

[ADMIN] Suse Linux Postgres

2007-10-25 Thread yogesh
Hello Frnds, I am using the Postgres on Linux, its the default that gets installed with the Suse Linux. Now when i run the psql command it ask for passwordI have created a role named "abccc" now i want to assign it a password..how to do it in Linux. before trying this I

Re: [ADMIN] Problem with PITR Past Particular WAL File

2007-10-25 Thread Alvaro Herrera
Craig McElroy wrote: > Alvaro: > I just tried, but I only get "No symbol table info available." after each > line of the trace. Well, we have two possibilities: 1. you send us a complete, reproducible test case, 2. you recompile with debugging enabled (configure --enable-debug) to get a more

Re: [ADMIN] Suse Linux Postgres

2007-10-25 Thread Scott Marlowe
On 10/25/07, yogesh <[EMAIL PROTECTED]> wrote: > Hello Frnds, > I am using the Postgres on Linux, its the default that gets > installed with the Suse Linux. > Now when i run the psql command it ask for passwordI have created > a role named "abccc" > now i want to assign it a password

Re: [ADMIN] Problem with PITR Past Particular WAL File

2007-10-25 Thread Tom Lane
Craig McElroy <[EMAIL PROTECTED]> writes: > Core was generated by `/usr/local/pgsql/bin/postgres -D /pgdata01/data'. > Program terminated with signal 11, Segmentation fault. > #0 0x080b8ee0 in entrySplitPage () > #1 0x080baccf in ginInsertValue () > #2 0x080b81b7 in gin_xlog_cleanup () > #3 0x

Re: [ADMIN] Problem with PITR Past Particular WAL File

2007-10-25 Thread Teodor Sigaev
#0 0x080b8ee0 in entrySplitPage () #1 0x080baccf in ginInsertValue () Corrupted stack? gin_xlog_cleanup() doesn't call ginInsertValue() directly. #2 0x080b81b7 in gin_xlog_cleanup () #3 0x080af4ce in StartupXLOG () #4 0x080c04ca in BootstrapMain () #5 0x08186b2f in StartChildProcess () #6

[ADMIN] Database Restore - time of last occurrence

2007-10-25 Thread smiley2211
Hello all, Is there a way to tell when was the LAST time a database was restored? I checked the pg_database system table but I'm not sure what 'datfrozenxid' means or if it means anything SELECT datname, age(datfrozenxid) FROM pg_database; Thanks...Michelle. -- View this message in contex

[ADMIN] Postgresql New login - password expiration???

2007-10-25 Thread smiley2211
Hello all, I've created a new Postgresql login and I set an expiration date on the account 'VALID until xx-xx-xxx'...will this require the user to CHANGE his password at expiration or will it DISABLE the user account??? Also, how do I set password expiration on new accounts??? ---I want them to

Re: [ADMIN] Problem with PITR Past Particular WAL File

2007-10-25 Thread Craig McElroy
Teodor: Thanks for the followup. We will be upgrading this system to 8.2.5 in the next day or so and will test it on that anyways just to be sure it isn't related. Let me know if there is anything else we can provide to help track down the bug. We will be keeping this base backup and

Re: [ADMIN] 32-bit to 64-bit migration screwup

2007-10-25 Thread Phillip Smith
I'm assuming you've made a jump in database version - ie, 7.4 to 8.2 or similar. You need to use initdb to create new database files, then pg_dumpall on the old system to dump the data out of the old before importing to the new. Make sure you use pg_dumpall from the new version to dump the data

Re: [ADMIN] 32-bit to 64-bit migration screwup

2007-10-25 Thread Devrim GÜNDÜZ
Hi, On Thu, 2007-10-25 at 22:52 -0700, David Young wrote: > FATAL: incorrect checksum in control file Did you move the old data files to the new server? If so, it won't work. Dump your 32-bit database with 32-bit binaries, and load that data to your 64-bit database. Regards, -- Devrim GÜNDÜZ P

[ADMIN] 32-bit to 64-bit migration screwup

2007-10-25 Thread David Young
All, I was hoping someone can help me fix a big blunder. I recently bought a new system to replace the old one. The new system is running 64bit linux and the old one 32bit. I installed PG 64-bit and tried to bring the old database back up. Even though I'm running the same version of PG, it is