Re: R: R: [GENERAL] Postgres 8.3-dev

2007-05-06 Thread Dave Page
Paolo Saudin wrote: I tried to set that policy to all available settings [activate, not activate, not set] but the result does not change, the installer stops with the same error. ... I then tried the same things on a true Windows XP Professional SP2 (not virtual machine) trying to set the

[GENERAL] shmget fails on OS X with proper settings

2007-05-06 Thread Christopher S Martin
Hi to the list, its my first post. I was previous running postgres 8.2.1 on my OS X 10.4.9 laptop with no problems. After I sent it to apple care, I found that I can no longer start the postmaster daemon. When I try, I receive the standard shmget failed error message: FATAL: could not create

Re: [GENERAL] shmget fails on OS X with proper settings

2007-05-06 Thread Martin Gainty
if you're getting memory errors then a guess would be did they take out any memory out of your machine or perhaps did they change your memory cache parameters??? Martin This email message and any files transmitted with it contain confidential information intended only for the person(s) to whom t

[GENERAL] did not find any relation for existing table

2007-05-06 Thread Sinead O Brien
Hello I am receiving a "did not find any relation" error in pgsql for a table which I know exists. The outputs from the commands are as follows cdx_post=# \d history.client; Did not find any relation named "history.client". cdx_post=# \dt history.clien* List of relations Schema

Re: [GENERAL] did not find any relation for existing table

2007-05-06 Thread Raymond O'Donnell
On 06/05/2007 23:05, Sinead O Brien wrote: cdx_post=# \d history.client; Did not find any relation named "history.client". Without actually trying it out myself, I wonder if the final semi-colon on your command is causing problems - as far as I recall (I don't use psql a whole lot), you need

Re: [GENERAL] shmget fails on OS X with proper settings

2007-05-06 Thread Christopher S Martin
Martin: They didn't take any memory out of the machine. AS for memory cache parameters, I'm don't know about that. How would I go checking for that type of thing? Thanks, Chris On 5/6/07, Martin Gainty <[EMAIL PROTECTED]> wrote: if you're getting memory errors then a guess would be did they

[GENERAL] Connections refused during backups

2007-05-06 Thread Glen Eustace
After an upgrade from 8.0.8 to 8.1.8, I am getting a number of our scripts failing with 'connection refused' at around 4:00am, which seems to be when the nightly database backup occurs. I am using "/usr/bin/pg_dump -Fc -b -c -C" to do the deed. Has there been a change in behavior, i.e. is the

Re: [GENERAL] did not find any relation for existing table

2007-05-06 Thread Sinead O Brien
Removing the semicolon gives the same output. cdx_post=# \d history.client Did not find any relation named "history.client". Without actually trying it out myself, I wonder if the final semi-colon on your command is causing problems - as far as I recall (I don't use psql a whole lot), you n

Re: [GENERAL] shmget fails on OS X with proper settings

2007-05-06 Thread Tom Lane
"Christopher S Martin" <[EMAIL PROTECTED]> writes: > I was previous running postgres 8.2.1 on my OS X 10.4.9 laptop with no > problems. > After I sent it to apple care, I found that I can no longer start the > postmaster daemon. When I try, I receive the standard shmget failed > error message:

Re: [GENERAL] shmget fails on OS X with proper settings

2007-05-06 Thread Scott Ribe
First off, use sysctl to see what values are actually being set: sysctl -a | grep kern.sysv. The if they're not what you think they should be, tell us exactly how you're trying to set them. -- Scott Ribe [EMAIL PROTECTED] http://www.killerbytes.com/ (303) 722-0567 voice

Re: [GENERAL] did not find any relation for existing table

2007-05-06 Thread Tom Lane
"Sinead O Brien" <[EMAIL PROTECTED]> writes: > I am receiving a "did not find any relation" error in pgsql for a table > which I know exists. Hm, what PG version is this? It might be that reindexing pg_class will fix it, but it would be nice to try to determine what's wrong before overwriting th

Re: [GENERAL] Connections refused during backups

2007-05-06 Thread Tom Lane
Glen Eustace <[EMAIL PROTECTED]> writes: > After an upgrade from 8.0.8 to 8.1.8, I am getting a number of our > scripts failing with 'connection refused' at around 4:00am, which seems > to be when the nightly database backup occurs. "Connection refused" is a kernel-level rejection, and at least

Re: [GENERAL] Connections refused during backups

2007-05-06 Thread Glen Eustace
Tom Lane wrote: "Connection refused" is a kernel-level rejection, and at least in theory should have nothing to do with what Postgres is doing. Did you do a kernel update at the same time? regards, tom lane My apologies, I shouldn't have used the generic socket error '

Re: [GENERAL] did not find any relation for existing table

2007-05-06 Thread Sinead O Brien
"Sinead O Brien" <[EMAIL PROTECTED]> writes: > I am receiving a "did not find any relation" error in pgsql for a table > which I know exists. Hm, what PG version is this? It might be that reindexing pg_class will fix it, but it would be nice to try to determine what's wrong before overwriting

Re: [GENERAL] Connections refused during backups

2007-05-06 Thread Tom Lane
Glen Eustace <[EMAIL PROTECTED]> writes: > My apologies, I shouldn't have used the generic socket error 'Connection > refused'. What I am getting are errors like > "Could not connect to database" from libnss-pgsql Please be *exact* rather than handwaving. What is the full text of the client-side

Re: [GENERAL] did not find any relation for existing table

2007-05-06 Thread Tom Lane
"Sinead O Brien" <[EMAIL PROTECTED]> writes: >>> I am receiving a "did not find any relation" error in pgsql for a table >>> which I know exists. >> >> Hm, what PG version is this? It might be that reindexing pg_class will >> fix it, but it would be nice to try to determine what's wrong before >>

Re: [GENERAL] Connections refused during backups

2007-05-06 Thread Glen Eustace
Tom Lane wrote: Glen Eustace <[EMAIL PROTECTED]> writes: My apologies, I shouldn't have used the generic socket error 'Connection refused'. What I am getting are errors like "Could not connect to database" from libnss-pgsql Please be *exact* rather than handwaving. What is the full text of t

Re: [GENERAL] Connections refused during backups

2007-05-06 Thread Tom Lane
Glen Eustace <[EMAIL PROTECTED]> writes: >>> My apologies, I shouldn't have used the generic socket error 'Connection >>> refused'. What I am getting are errors like >>> "Could not connect to database" from libnss-pgsql > This is the exact message from libnss-pgsql, While you are at it, you shou

[GENERAL] Buena documentacion

2007-05-06 Thread Jenny Ortiz
Hola, lei en el grupo sobre este enlace de los libros de postgress que se venden. Parecen buenos, buscare mas informacion sobre ellos.Muchas gracias. http://www.postgresql.org/docs/books/ Saludos, http://gjortiz.blogspot.com";>Jenny Ortiz __

Re: [GENERAL] did not find any relation for existing table

2007-05-06 Thread Sinead O Brien
8.0.3 is more than two years old --- you really ought to update to the latest in that branch (8.0.13 currently), if not upgrade to 8.1.x or 8.2.x branches. I do see a post-8.0.3 fix that might explain loss of index entries, so trying a reindex is worth doing at this point. Thank you very muc

Re: [GENERAL] Buena documentacion

2007-05-06 Thread Martin Gainty
solamente ingles.. porfavor M This email message and any files transmitted with it contain confidential information intended only for the person(s) to whom this email message is addressed. If you have received this email message in error, please notify the sender immediately by telephone or emai