Re: [ADMIN] failing to compile v. 9.0.1 on debian squeeze with readline

2010-12-06 Thread Imre Oolberg
Hi! Sorry for the noise, it was mostly my bad, people told me i needed to have libreadline6-dev package installed, from there come among other things two links lrwxrwxrwx 1 root root 20 Dec 6 09:57 /usr/lib/libhistory.so - /lib/libhistory.so.6 lrwxrwxrwx 1 root root 21 Dec 6 09:57

Re: [ADMIN] h--.

2010-12-06 Thread Rohan Rasane
Recently, I bought some presents from a commercial site for Christmas, all the products can enjoy a big discount, it is worth visiting: cnelebuy.com , for the Christmas more one choice. y--. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription:

[ADMIN] Certificate location under Windows 7

2010-12-06 Thread Lou Picciano
Hello Friends... Can anyone here make a definitive statement about a known working (default) location for certificates under Windows 7? We've had some trouble identifying where pqlib expects them... Many thanks in advance, Lou

[ADMIN] GSSAPI v9.01

2010-12-06 Thread dx k9
Hi All, I'm getting an error when trying to log into a database with gss( 1st time trying, see command below ). My postgres user name is bob and my system name is also bob to log into the SLES 9 or SLES 11 box. Although the active directory name is b...@domain.comSo, I'm not using

Re: [ADMIN] COPY statement for linux server from windows client

2010-12-06 Thread Szymon Guz
On 6 December 2010 19:44, Lukasz Brodziak lukasz.brodz...@gmail.com wrote: Hello, I have a problem with creating a COPY TO statement with windows client application which connects to PG 8.2 (soon will be moved to PG 9.0) installed on linux. Everytime I try to do this using open file dialog

Re: [ADMIN] failing to compile v. 9.0.1 on debian squeeze with readline

2010-12-06 Thread Peter Eisentraut
On mån, 2010-12-06 at 00:29 +0200, Imre Oolberg wrote: 4. compile $ make ... gcc -O2 -Wall -Wmissing-prototypes ... ... postmaster/postmaster.o: In function `PostmasterMain': postmaster.c:(.text+0x420c): undefined reference to `optreset' tcop/postgres.o: In function

[ADMIN] monitor SQL activity in db

2010-12-06 Thread Isabella Ghiurea
Hi Gurus, I'm running PG 9.0.1 and have some issues with some SQL, I would like to know if are other system views/tables beside the pg_stat_activity from where I can get details about a running transactions / SQL at given time. Thank you Isabella --

Re: [ADMIN] failing to compile v. 9.0.1 on debian squeeze with readline

2010-12-06 Thread Imre Oolberg
Peter Eisentraut wrote: I compile PostgreSQL on Debian squeeze about 10 times a day and I have never seen that. Could you show the output of dpkg -l \*readline\* As i wrote my problem was solved after installing libreadline6-dev (it was stupid of me not to check that in the first

Re: [ADMIN] pg_* Tables

2010-12-06 Thread Samuel Stearns
Yep, small row counts. Thanks, Greg! From: Greg Williamson [mailto:gwilliamso...@yahoo.com] Sent: Monday, 6 December 2010 5:34 PM To: Samuel Stearns; pgsql-admin@postgresql.org Subject: Re: [ADMIN] pg_* Tables Samuel Stearns wrote: Howdy, Environment: Solaris 10 Postgres 8.3.3 I’m