[ADMIN] UNSUBSCRIBE

2007-02-22 Thread VivekanandaSwamy R.
Hi.. Please unsubscribe me. Thanks Vivek.R Information transmitted by this e-mail is proprietary to Infinite Computer Solutions and / or its Customers and is intended for use only by the individual or the entity to which it is addressed, and may contain information that is privileged,

Re: [ADMIN] UNSUBSCRIBE

2007-02-22 Thread Danyelle Gragsone
maybe you should read on how to unsubscribe ;) On 2/22/07, VivekanandaSwamy R. <[EMAIL PROTECTED]> wrote: Hi.. Please unsubscribe me. Thanks Vivek.R Information transmitted by this e-mail is proprietary to Infinite Computer Solutions and / or its Customers and is intended for use only

Re: [ADMIN] [pgadmin-support] UNSUBSCRIBE

2007-02-22 Thread Andy Shellam (Mailing Lists)
To all who want unsubscribing, it is best to fill out this form: http://www.postgresql.org/community/lists/subscribe Regards, Andy. ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs

[ADMIN] UIDs/GIDs for hacluster and haclient

2007-02-22 Thread Doug Knight
Hi all, I'm setting up a first time HA using v2, and was wondering if there are any recommendations/guidelines/gotchas with UID/GID assignment for the hacluster account and haclient group? Thanks, Doug Knight WSI Inc.

Re: [ADMIN] UIDs/GIDs for hacluster and haclient

2007-02-22 Thread Doug Knight
Sorry all, finger slip on email group selection... ;) On Thu, 2007-02-22 at 09:24 -0500, Doug Knight wrote: > Hi all, > I'm setting up a first time HA using v2, and was wondering if there > are any recommendations/guidelines/gotchas with UID/GID assignment for > the hacluster account and haclient g

[ADMIN] Silent Install of 8.2 on Windows

2007-02-22 Thread Ian Charters
Am trying to install with the following batch file msiexec /qb+ /l*v "C:\psql_installer\log.txt" /i postgresql-8.2.msi INTERNALLAUNCH="1" ADDLOCAL=server,psql SERVICEDOMAIN="%COMPUTERNAME%" CREATESERVICEUSER="1" SERVICEACCOUNT="pg82" SERVICEPASSWORD="pg82" SUPERUSER="postgres" SUPERPASSWORD="069

[ADMIN] Fastest DB restore options

2007-02-22 Thread ogjunk-pgjedan
Hello, I have a fairly large DB to dump and restore as fast as possible. I'm moving from 8.0.3 to 8.2.3! :) I normally dump with these options: -d MyDB --clean --inserts --column-inserts --format=P But the last time I tried that, the restore took foreever. So I'm looking for t

Re: [ADMIN] Fastest DB restore options

2007-02-22 Thread Joshua D. Drake
[EMAIL PROTECTED] wrote: > Hello, > > I have a fairly large DB to dump and restore as fast as possible. I'm moving > from 8.0.3 to 8.2.3! :) > > I normally dump with these options: > > -d MyDB --clean --inserts --column-inserts --format=P > > But the last time I tried that, the restore took

Re: [ADMIN] Fastest DB restore options

2007-02-22 Thread Naomi Walker
Consider leaving all indicies off until the load finishes... Naomi [EMAIL PROTECTED] wrote: > Hello, > > I have a fairly large DB to dump and restore as fast as possible. I'm moving > from 8.0.3 to 8.2.3! :) > > I normally dump with these options: > > -d MyDB --clean --inserts --column-insert

Re: [ADMIN] Fastest DB restore options

2007-02-22 Thread Tom Lane
[EMAIL PROTECTED] writes: > I normally dump with these options: > -d MyDB --clean --inserts --column-inserts --format=P > But the last time I tried that, the restore took foreever. --inserts is pretty expensive. > So I'm looking for the fastest way to import data from the old DB to

[ADMIN] UNSUBSCRIBE

2007-02-22 Thread jose carlos de la toba duarte
Hi.. Please unsubscribe me. Thanks Jose Carlos _ Live Search en Prodigy/MSN. Todo lo que buscas ahora más rapido http://live.com ---(end of broadcast)--- TIP 3: Have you ch

Re: [ADMIN] UNSUBSCRIBE

2007-02-22 Thread Danyelle Gragsone
To all who want unsubscribing, it is best to fill out this form: http://www.postgresql.org/community/lists/subscribe Regards, Andy. On 2/22/07, jose carlos de la toba duarte <[EMAIL PROTECTED]> wrote: Hi.. Please unsubscribe me. Thanks Jose Carlos _

Re: [ADMIN] Fastest DB restore options

2007-02-22 Thread ogjunk-pgjedan
- Original Message From: Tom Lane <[EMAIL PROTECTED]> [EMAIL PROTECTED] writes: > I normally dump with these options: > -d MyDB --clean --inserts --column-inserts --format=P > But the last time I tried that, the restore took foreever. --inserts is pretty expensive. OG: rig

[ADMIN] Online archiving

2007-02-22 Thread Karthikeyan Sundaram
Hi, My database is very big and would like to perform an online archiving. I haven't done this before. Can you please throw some lite on this (i.e., how to do this and the steps if anybody has done this). Regards skarthi _

Re: [ADMIN] Fastest DB restore options

2007-02-22 Thread Alvaro Herrera
[EMAIL PROTECTED] wrote: > > -d MyDB --format=c --ignore-version > > Don't use --ignore-version; it's a good way to shoot yourself in the foot. > > OG: even when upgrading (8.0.3 -> 8.2.3)? I'll dump with pg_dump from 8.0.3 > and them import with pg_restore from the newly installed 8.2.3.

Re: [ADMIN] Online archiving

2007-02-22 Thread Joshua D. Drake
Karthikeyan Sundaram wrote: > Hi, > >My database is very big and would like to perform an online > archiving. I haven't done this before. Can you please throw some lite > on this (i.e., how to do this and the steps if anybody has done this). (10:17:03 AM) linuxpoet: ??PITR (10:17:04 AM) rt

[ADMIN] pg_hba.conf multiple auth_metods question

2007-02-22 Thread Gémes Géza
Hi, I have successfully deployed krb5 or pam (with pam_krb5) authentication with my clients. My question is: Can I use both in a failover fashion? What I try to achieve: Users having kerberos tickets get authenticated with the krb5 auth_metod, if they don't have the right ticket they get prom

Re: [ADMIN] Fastest DB restore options

2007-02-22 Thread Marco Bizzarri
On 2/22/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: Hello, I have a fairly large DB to dump and restore as fast as possible. I'm moving from 8.0.3 to 8.2.3! :) I normally dump with these options: -d MyDB --clean --inserts --column-inserts --format=P But the last time I tried that, th

[ADMIN] UNSUBSCRIBE

2007-02-22 Thread Nabil Sawaya
---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly

Re: [ADMIN] Fastest DB restore options

2007-02-22 Thread ogjunk-pgjedan
Hi, Yes, In remember discussions about (f)sync config. Can anyone comment on whether turning fsync off for a restore into 8.2.3: 1) is advisable 2) will make the restore faster If the OS and FS matter, this is on a Fedora Core3 Linux with kernel 2.6.9 and the ext3 journaling FS. Thanks, Otis

Re: [ADMIN] pg_hba.conf multiple auth_metods question

2007-02-22 Thread Peter Eisentraut
Gémes Géza wrote: > I have successfully deployed krb5 or pam (with pam_krb5) > authentication with my clients. > My question is: Can I use both in a failover fashion? Not in PostgreSQL, but you could probably hook Kerberos into PAM. -- Peter Eisentraut http://developer.postgresql.org/~petere/ -