Re: [ADMIN] Specific questions about wraparound and vacuum

Hi, thanks alot for your answers. Yesterday I have updated the kernel. After a reboot, the ECC-Kernel error still appears. Then I've cleaned the RAM-Slots with nose-paper :), rebooted the machine, and the error was away! Unbelievable, the error was before on both the machines. Yesterday night,

[ADMIN] not able to setup tsearch2 synonym dictionary

Hi , I am trying to setup a synonym dictionary setup using instructions in http://people.planetpostgresql.org/mha/index.php?/archives/118-Custom-synonym-dictionaries-in-tsearch2.html after following all the steps lexize is not doing the expected eg tradein_clients=# SELECT * from public.pg_ts

[ADMIN] Delete COLUMN data

Hello all, I need to DELETE all the DATA from 3 columns in my table...what is the BEST way to handle this??? I don't want to DROP the columns just clear out ALL the data in those 3 fields... Thanks...Michelle -- View this message in context: http://www.nabble.com/Delete-COLUMN-data-tf4242917.

Re: [ADMIN] Specific questions about wraparound and vacuum

Hi, thanks alot for your answers. Yesterday I have updated the kernel. After a reboot, the ECC-Kernel error still appears. Then I've cleaned the RAM-Slots with nose-paper :), rebooted the machine, and the error was away! Unbelievable, the error was before on both the machines. Yesterday nig

Re: [ADMIN] Delete COLUMN data

It is called "update": UPDATE SET = NULL, = NULL, = NULL; -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of smiley2211 Sent: Thursday, August 09, 2007 10:27 AM To: pgsql-admin@postgresql.org Subject: [ADMIN] Delete COLUMN data Hello all, I need to D

Re: [ADMIN] Delete COLUMN data

hmmm... I was just thinking...maybe using UPDATE to NULL field value would be an option Update tblname set field1 = NULL; Thanks...Michelle smiley2211 wrote: > > Hello all, > > I need to DELETE all the DATA from 3 columns in my table...what is the > BEST way to handle this??? I don't w

Re: [ADMIN] Delete COLUMN data

How about: UPDATE table_name SET column1 = NULL, column2 = NULL, column3 = NULL > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of smiley2211 > Sent: Thursday, August 09, 2007 10:27 AM > To: pgsql-admin@postgresql.org > Subject: [ADMIN] Delete CO

Re: [ADMIN] Delete COLUMN data

THANKS ALL FOR YOUR REPLIES...THIS WORKED JUST FINE. -- View this message in context: http://www.nabble.com/Delete-COLUMN-data-tf4242917.html#a12075308 Sent from the PostgreSQL - admin mailing list archive at Nabble.com. ---(end of broadcast)---

[ADMIN]

Good afternoon, We have a situation where we call our central queue processor from a remote machine using a Perl script. We can process up to 1500 'type 1' records followed by 5 'type 2 records. We process any number successfully Before we get the following error: ERROR: could not send da

Re: [ADMIN]

On Thu, Aug 09, 2007 at 01:05:16PM -0400, Mark Steben wrote: > > ERROR: could not send data to client: Broken pipe > When we run this manually on the local machine we do not get this error. It > is a Postgres function that is called. Is there a firewall in between that is timing out the TCP

Re: [ADMIN]

Hi! Is there a NAT firewall or something like it involved anywhere between the two machines? If so, the connection may time out at some point in time, and neither server nor client would be notified that the connection is lost. An "ERROR: could not send data to client: Broken pipe" message indi

Re: [ADMIN] Joining tables in two different databases?

On 8/8/07, Michael Goldner <[EMAIL PROTECTED]> wrote: > > Is it possible to access tables in two different databases, running on > the > same server, from within psql? > Take a look at dblink in the contrib area. I think it will give you what you are looking for. Chris

Re: [ADMIN] Specific questions about wraparound and vacuum

On Wed, Aug 08, 2007 at 09:55:54PM -0400, Nick Fankhauser wrote: > We did in fact just increase the fsm values significantly based on the > feedback we were getting from the vacuum messages. We do nightly > non-full vacuums. Am I to understand that if we increase our fsm > allocation to a sufficien

[ADMIN] entries in serverlog file

Hi everybody, I have, by default, on a linux machine, a file called serverlog in the data directory, whose entries often prove to be very useful. What would be even more useful would be a timestamp along with each entry. Is there any way I can add such timestamp at this point? Perhaps via postgr

Re: [ADMIN] entries in serverlog file

>>> On Thu, Aug 9, 2007 at 4:37 PM, in message <[EMAIL PROTECTED]>, "Tena Sakai" <[EMAIL PROTECTED]> wrote: > I have, by default, on a linux machine, a file called > serverlog in the data directory, whose entries often > prove to be very useful. What would be even more useful > would be a timest

Re: [ADMIN] entries in serverlog file

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Tena Sakai wrote: > Hi everybody, > > I have, by default, on a linux machine, a file called > serverlog in the data directory, whose entries often > prove to be very useful. What would be even more useful > would be a timestamp along with each entry.

Re: [ADMIN] entries in serverlog file

Hi Joshua, Hi Kevin, Many thanks for your suggestions/advices. I am reading chapter 17 of the manual, which in the hindsight, I should have read a month ago. But this is very good. I am making haste slowly. Thanks again. Regards, Tena Sakai [EMAIL PROTECTED]

[ADMIN] Postgres and PAM config issues

Hi, I'm trying to set up my DB to authenticate against a PAM back-end (in this case just a plain old local password DB). Here's my configuration as it currently stands: positionwhile[pg]% grep pam /var/lib/pgsql/metadata/pg_hba.conf # "krb4", "krb5", "ident", or "pam". Note that "p