Re: [ADMIN] YOUR SITES SEARCH FEATURE DOES NOT WORK!

2003-09-03 Thread matt
This is not facetious, honestly, but what about google? site:archives.postgresql.org +OS X +terminal returns just a couple of pages... Of course there's no date ordering as such, although +2003 works fairly well, as does +[ADMIN]. Not a panacea I know, but it's quick, and it does have the

Re: [ADMIN] postgresql and replication

2003-09-03 Thread hugo_rousse
I am unable to find the adress to unsuscribe, could you please help me and give me that adress... thanks for advance!! Message d'origine Date: Tue, 2 Sep 2003 17:21:05 -0300 (ADT) De: Marc G. Fournier [EMAIL PROTECTED] A: Somasekhar Bangalore [EMAIL PROTECTED] Copie à: Andrew Sullivan

[ADMIN] pg_recvbuf : unexpected EOF on client

2003-09-03 Thread Priya G
what does the error in postgres.log pg_recvbuf : unexpected EOF on client mean? thanks in advance Sree Get MSN 8 and help protect your children with advanced parental controls.

Re: [ADMIN] pg_recvbuf : unexpected EOF on client

2003-09-03 Thread Peter Eisentraut
Priya G writes: what does the error in postgres.log pg_recvbuf : unexpected EOF on client mean? The client closed the connection (on the operating system level) before properly closing the session (on the PostgreSQL level). Either you have a buggy client that does that out of principle, or the

Re: [ADMIN] YOUR SITES SEARCH FEATURE DOES NOT WORK!

2003-09-03 Thread Ian Barwick
On Wednesday 03 September 2003 09:42, Ian Barwick wrote: On Wednesday 03 September 2003 00:26, Marc G. Fournier wrote: okay, first off ... what URL? I've been working on, and testing, archives all week, and altho getting things down below a 2min search appears to be near impossible (anyone

[ADMIN] Dumping select tables (omitting tables)

2003-09-03 Thread Yuji Shinozaki
I would like to dump select tables from a database (omitting some tables). It looks like pg_dump only allows you to dump the entire database or select single tables to dump. Is there a way to specify to pg_dump a list of tables to dump (or to omit)? I can dump all the desired tables as single

[ADMIN] Backup - Restore (pg-dump)

2003-09-03 Thread creid
Any Help I recently upgraded to 7.3.4 from 7.3.2. Prior to the upgrade I used pg_dump -a olddatafile for just data and pg_dump -s oldschemafile for schema using the pg_dump utility from 7.3.2. After a successful install of 7.3.4, I created the database then went on to successful psql -f

Re: [ADMIN] Backup - Restore (pg-dump)

2003-09-03 Thread Peter Eisentraut
creid writes: I recently upgraded to 7.3.4 from 7.3.2. Prior to the upgrade I used pg_dump -a olddatafile for just data and pg_dump -s oldschemafile for schema using the pg_dump utility from 7.3.2. After a successful install of 7.3.4, I created the database then went on to successful

[ADMIN] Problems Starting Postgres as a Service

2003-09-03 Thread Nick Stone
Hi I am trying to run Postgres on Windows as a service and after a bit of playing around I can run it from within Cygwin and I can install it as a service OK but when I try to start the service I get the following error: IpcMemoryCreate: shmget(key=5432001, size=1499136, 03600) failed: Not

Re: [ADMIN] language plpgsql does not exist

2003-09-03 Thread Bruce Momjian
Renney Thomas wrote: You have to install the procedural language into each database as such: 1. su - postgres 2. createlang plpgsql [your dbname here] I still think we should display a 'hint' that createlang might fix the problem when we report a problem with a missing language --- these

Re: [ADMIN] Problems Starting Postgres as a Service

2003-09-03 Thread Ian Huynh
while postgres is pretty solid under unixes, i am just curious as regards to the stability of cygwin+Postgres combo under win2k? -Original Message- From: Nick Stone [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 03, 2003 1:57 AM To: '[EMAIL PROTECTED]' Subject: [ADMIN] Problems

Re: [ADMIN] Dumping select tables (omitting tables)

2003-09-03 Thread Bruce Momjian
Yuji Shinozaki wrote: I would like to dump select tables from a database (omitting some tables). It looks like pg_dump only allows you to dump the entire database or select single tables to dump. Is there a way to specify to pg_dump a list of tables to dump (or to omit)? I can dump

[ADMIN] unsubscrib

2003-09-03 Thread AlmawElias Fantahun
please remove me from the list _ MSN 8: Get 6 months for $9.95/month http://join.msn.com/?page=dept/dialup ---(end of broadcast)--- TIP 7: don't forget to increase your free space map

Re: [ADMIN] How to read a sequence without incrementing it?

2003-09-03 Thread scott.marlowe
Just FYI, SELECT last_value FROM my_sequence; is NOT transaction safe, i.e. other transactions may increment the counter between the time you run that query and the next that uses the value. On Sat, 30 Aug 2003, Pierre Couderc wrote: Thank you all. SELECT last_value FROM my_sequence; is

Re: [ADMIN] unsubscrib

2003-09-03 Thread AlmawElias Fantahun
yes please unsubscrib me From: AlmawElias Fantahun [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: [ADMIN] unsubscrib Date: Wed, 03 Sep 2003 23:06:33 + please remove me from the list _ MSN 8: Get 6 months for $9.95/month

[ADMIN] SQL slower when running for the second time

2003-09-03 Thread Rhaoni Chiu Pereira
Hi List, I trying to increase performance in my PostgreSQL but there is something wrong.when I run this SQL for the first time it takes 1 min. 40 seconds to return, but when I run it for the second time it takes more than 2 minutes, and I should retunr faster than the first time. Does

Re: [ADMIN] SQL slower when running for the second time

2003-09-03 Thread Peter Eisentraut
Rhaoni Chiu Pereira writes: I trying to increase performance in my PostgreSQL but there is something wrong.when I run this SQL for the first time Which SQL? it takes 1 min. 40 seconds to return, but when I run it for the second time it takes more than 2 minutes, and I should retunr