Re: [GENERAL] Server Not Running

2011-08-04 Thread Adarsh Sharma
Thanks Sim , I solved the problem . It's due to my pg_xlog is not mounted in the server. Cheers! Sim Zacks wrote: On 08/04/2011 08:46 AM, Adarsh Sharma wrote: Dear all, Today I do some changes in postgresql.conf &shmmax parameters as : root~# cat /proc/sys/kernel/shmall 8388608 root~# cat /

[GENERAL] failed to start postgresql service

2011-08-04 Thread Gergely Buday
Hi there, I created a directory /usr/local/pgsql/data to store the data of postgresql and ran $ initdb -D /usr/local/pgsql/data After that, I tried to start the postgresql service on my fedora 15 box via $ sudo service postgresql start but it has failed with the message Starting postgresql (v

Re: [GENERAL] failed to start postgresql service

2011-08-04 Thread Jerry Sievers
Gergely Buday writes: > Hi there, > > I created a directory /usr/local/pgsql/data to store the data of > postgresql and ran > > $ initdb -D /usr/local/pgsql/data > > After that, I tried to start the postgresql service on my fedora 15 box via > > $ sudo service postgresql start > > but it has fail

Re: [GENERAL] failed to start postgresql service

2011-08-04 Thread Gergely Buday
> Set and export the PGDATA variable in the rc script to the data > dirrectory path and try again. Thanks it worked. - Gergely -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] query to get the list of key (reserverd) words?

2011-08-04 Thread Bill Moran
I'm in the unenviable position of needing to check various input to ensure that it doesn't contain any PostgreSQL/SQL key words/reserved words. The initial implementation simply made a copy of this table: http://www.postgresql.org/docs/8.3/static/sql-keywords-appendix.html#KEYWORDS-TABLE into a s

[GENERAL]

2011-08-04 Thread Steven Boyd
Good morning!   When I installed version 8.3.12, I used a local account as the service account. Well, we're getting into an issue where because it's a local account it gets removed from the "logon as a service" list because its not a domain account (part of our global policy object).    So my q

Re: [GENERAL] query to get the list of key (reserverd) words?

2011-08-04 Thread Peter Geoghegan
On 4 August 2011 13:53, Bill Moran wrote: > Is there a pg_* or other table in the database that I can query for this > list?  Or some other automated method that can be employed? All keywords are listed in src/backend/parser/gram.y: /* ordinary key words in alphabetical order */ %token ABORT_P

[GENERAL] local server service account

2011-08-04 Thread Steven Boyd
Good morning!   When I installed version 8.3.12, I used a local account as the service account. Well, we're getting into an issue where because it's a local account it gets removed from the "logon as a service" list because its not a domain account (part of our global policy object).    So my q

Re: [GENERAL] query to get the list of key (reserverd) words?

2011-08-04 Thread Tom Lane
Bill Moran writes: > Is there a pg_* or other table in the database that I can query for this > list? Or some other automated method that can be employed? In recent versions, "select * from pg_get_keywords()" regards, tom lane -- Sent via pgsql-general mailing list (pg

Re: [GENERAL] local server service account

2011-08-04 Thread Craig Ringer
On 4/08/2011 9:28 PM, Steven Boyd wrote: Good morning! When I installed version 8.3.12, I used a local account as the service account. Well, we're getting into an issue where because it's a local account it gets removed from the "logon as a service" list because its not a domain account (part

Re: [GENERAL] query to get the list of key (reserverd) words?

2011-08-04 Thread Bill Moran
In response to Tom Lane : > Bill Moran writes: > > Is there a pg_* or other table in the database that I can query for this > > list? Or some other automated method that can be employed? > > In recent versions, "select * from pg_get_keywords()" That's fantastic ... exactly what I needed to mak

Re: [GENERAL] hstore installed in a separate schema

2011-08-04 Thread Harald Fuchs
In article <1312401318.5199.yahoomailclas...@web120108.mail.ne1.yahoo.com>, Ioana Danes writes: > Hi, > I am planning to use the contrib module hstore > but I would like to install it on a separate schema, not public, > and include the schema in the search_path. > Do you know if there are any

Re: [GENERAL] query to get the list of key (reserverd) words?

2011-08-04 Thread Igor Neyman
> -Original Message- > From: Bill Moran [mailto:wmo...@potentialtech.com] > Sent: Thursday, August 04, 2011 8:53 AM > To: pgsql-general@postgresql.org > Subject: query to get the list of key (reserverd) words? > > > I'm in the unenviable position of needing to check various input to > e

[GENERAL] Is there a better way to unnest an entire row?

2011-08-04 Thread David Johnston
Currently I have a de-normalized table with two sets of "records" embedded (i.e., [id, item1_name, item1_amount, item2_name, item2_amount]). My goal is to output two records (i.e., [id, item_name, item_amount]) into an intermediate result and then remove any records where item_name IS NULL or "bl

Re: [GENERAL] Is there a better way to unnest an entire row?

2011-08-04 Thread David Johnston
From: Michael Black [mailto:michaelblack75...@hotmail.com] Sent: Thursday, August 04, 2011 6:42 PM To: pol...@yahoo.com Subject: RE: [GENERAL] Is there a better way to unnest an entire row? I do not see where you would need to do a self-join on the table. However, a union would work nice t