[ADMIN] UNSUBSCRIBE

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

Re: [ADMIN] UNSUBSCRIBE

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

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?

[ADMIN] UIDs/GIDs for hacluster and haclient

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

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

[ADMIN] Silent Install of 8.2 on Windows

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=06969

[ADMIN] Fastest DB restore options

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

Re: [ADMIN] Fastest DB restore options

[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

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-inserts

Re: [ADMIN] Fastest DB restore options

[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

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

Re: [ADMIN] UNSUBSCRIBE

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

- 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: right.

[ADMIN] Online archiving

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

[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

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)

[ADMIN] pg_hba.conf multiple auth_metods question

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

Re: [ADMIN] Fastest DB restore options

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, the

[ADMIN] UNSUBSCRIBE

---(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

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

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/