Re: [GENERAL] PostgreSQL 9.2 and PGBOUNCER

2013-01-07 Thread Birta Levente
On 08/01/2013 08:40, a...@hsk.hk wrote: Hi, My PostgreSQL is 9.2.1 in Ubuntu 12.04, I need to set up a connection pool by using pgbouncer. I used "apt-get install pgbouncer", after configuring it, I can now connect to pgbouncer and can use all pgbouncer SHOW commands, however: Q1) Is versi

[GENERAL] PostgreSQL 9.2 and PGBOUNCER

2013-01-07 Thread a...@hsk.hk
Hi, My PostgreSQL is 9.2.1 in Ubuntu 12.04, I need to set up a connection pool by using pgbouncer. I used "apt-get install pgbouncer", after configuring it, I can now connect to pgbouncer and can use all pgbouncer SHOW commands, however: Q1) Is version "1.4.2/bouncer" the right one for Pos

Re: [GENERAL] Unnecessary files that can be deleted/moved in cluster dir?

2013-01-07 Thread Raghavendra
On Fri, Jan 4, 2013 at 5:01 AM, John Abraham wrote: > I have a little problem, I let my drive get too full. And then while I > was deleting rows to free space, the auto vacuum didn't kick in quite the > way I expected, and I ran out of space entirely. So the DB shut down and > won't start bac

Re: [GENERAL] Unnecessary files that can be deleted/moved in cluster dir?

2013-01-07 Thread Craig Ringer
On 4/01/2013 7:31 AM, John Abraham wrote: > I have a little problem, I let my drive get too full. And then while I was > deleting rows to free space, the auto vacuum didn't kick in quite the way I > expected, and I ran out of space entirely. So the DB shut down and won't > start back up. > >

Re: [GENERAL] Database Design: Maintain Audit Trail of Changes

2013-01-07 Thread Craig Ringer
On 4/01/2013 12:09 AM, Adrian Klaver wrote: > On 01/03/2013 07:38 AM, Rich Shepard wrote: > >> >>The middleware of the application needs to check this table when data >> are >> to be viewed in the UI and present only the current row contents. A >> separate >> view would display a history of cha

Re: [GENERAL] PostgreSQL run as process in windows

2013-01-07 Thread Craig Ringer
On 01/03/2013 12:51 PM, tuanhoanganh wrote: > On Thu, Jan 3, 2013 at 11:04 AM, John R Pierce > wrote: > > of course, a pooler only works right if the client applications > are modified to open a connection, do a transaction, and close the > connection. if t

Re: [GENERAL] PostgreSQL run as process in windows

2013-01-07 Thread Craig Ringer
On 01/03/2013 04:46 PM, Alban Hertroys wrote: > FYI: There's a kernel sockets leak in the 64-bit edition of that OS in > combination with multiple CPU cores (meaning on any slightly modern > CPU). You might be running into that now or later. > See: http://support.microsoft.com/?id=2577795 > > The i

Re: [GENERAL] spring a string to rows (Postgresql 8.4)

2013-01-07 Thread Moshe Jacobson
select id, unnest(regexp_split_to_array(col1, ',\s+')) On Mon, Jan 7, 2013 at 2:44 PM, Emi Lu wrote: > Hello, > > Is there a function to split a string to different rows? > > For example, t1(id, col1) > values(1, 'a, b, c'); > > select id, string_split_to_row(col1, ','); > > Return: > =

Re: [GENERAL] spring a string to rows (Postgresql 8.4)

2013-01-07 Thread Thomas Kellerer
Emi Lu wrote on 07.01.2013 20:44: Hello, Is there a function to split a string to different rows? For example, t1(id, col1) values(1, 'a, b, c'); select id, string_split_to_row(col1, ','); Return: = 1, a 1, b 1, c Thanks alot! Emi select id, regexp_split_to_table(col1, ',') fro

Re: [GENERAL] spring a string to rows (Postgresql 8.4)

2013-01-07 Thread Raymond O'Donnell
On 07/01/2013 19:44, Emi Lu wrote: > Hello, > > Is there a function to split a string to different rows? > > For example, t1(id, col1) > values(1, 'a, b, c'); regexp_split_to_table() should do it: http://www.postgresql.org/docs/8.4/static/functions-string.html HTH Ray. -- Raymond O'Donne

[GENERAL] spring a string to rows (Postgresql 8.4)

2013-01-07 Thread Emi Lu
Hello, Is there a function to split a string to different rows? For example, t1(id, col1) values(1, 'a, b, c'); select id, string_split_to_row(col1, ','); Return: = 1, a 1, b 1, c Thanks alot! Emi -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make change

Re: [GENERAL] lc_time not working?

2013-01-07 Thread Adrian Klaver
On 01/07/2013 07:56 AM, Tom Lane wrote: Adrian Klaver writes: On 01/07/2013 06:45 AM, J. Hondius wrote: I'm not getting my PostgreSQL 9.2 to return the correct lc_time openwave001=# select set_config('lc_time', 'nl_NL', true); When you use true it only applies for that transaction. But

Re: [GENERAL] currval of sequence xxx_seq is not yet defined in this session?

2013-01-07 Thread Tom Lane
kenyon writes: > recently i found some errors in pg_log when i do some pressure testing,looks > like > "2013-01-05 21:48:29.870 > CST,"postgres","wedding",15850,"172.25.10.28:37100",50e82f2d.3dea,1,"SELECT",2013-01-05 > 21:48:29 CST,19/80509,0,ERROR,55000,"currval of sequence > ""t_wedding_weddi

Re: [GENERAL] lc_time not working?

2013-01-07 Thread Tom Lane
Adrian Klaver writes: > On 01/07/2013 06:45 AM, J. Hondius wrote: >> I'm not getting my PostgreSQL 9.2 to return the correct lc_time >> openwave001=# select set_config('lc_time', 'nl_NL', true); > When you use true it only applies for that transaction. But he has the same setting in postgresql.

Re: [GENERAL] lc_time not working?

2013-01-07 Thread Adrian Klaver
On 01/07/2013 06:45 AM, J. Hondius wrote: Hi All, please advise I'm not getting my PostgreSQL 9.2 to return the correct lc_time See psql output below. lc_monetary and the lc's do work correctly postgresql.conf is set to lc_time = 'nl_NL' the output of locale -a includes nl_NL [root@d01 ~]# psq

[GENERAL] lc_time not working?

2013-01-07 Thread J. Hondius
Hi All, please advise I'm not getting my PostgreSQL 9.2 to return the correct lc_time See psql output below. lc_monetary and the lc's do work correctly postgresql.conf is set to lc_time = 'nl_NL' the output of locale -a includes nl_NL [root@d01 ~]# psql db user psql (9.2.1) Type "help" for help