Re: [ADMIN] failing to compile v. 9.0.1 on debian squeeze with readline
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 /usr/lib/libreadline.so - /lib/libreadline.so.6 And as a result the optreset and setproctitle parameters get set to 'no'. Although during apt-get build-dep postgresql-8.3 on lenny (v. 5.0) it installs libreadline5-dev but on squeeze (v. 6.0) neither of the -dev packages gets installed (need to lobby debian package managers on that!). Thanks for your replies! Imre Tom Lane wrote: Devrim =?ISO-8859-1?Q?G=DCND=DCZ?= dev...@gunduz.org writes: On Sun, 2010-12-05 at 17:49 -0500, Tom Lane wrote: Maybe you need to lobby the Debian folks to revert to a less broken version of libreadline. It surely has got no business exporting either of those symbols. Could it be libreadline5 vs libreadline 6? Fedora has been shipping readline 6.1 for awhile, and I see no such misbehavior there. regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
Re: [ADMIN] h--.
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: http://www.postgresql.org/mailpref/pgsql-admin
[ADMIN] Certificate location under Windows 7
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
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 pg_ident (user name maps) . Do I need to configure --wtih-kerberos, see way below in my configure command below. Maybe, both kerberos and gssapi are needed for gssapi, see configure command below. Section 19.3.3 talks about include_realm, map and krb_realm but I'm not seeing those option in pg_hba. Is it referring to the krb5.conf file? Thanks for any help, ~DjK Version 9.01 psql -h server -U bob psql: GSSAPI continuation error: Unspecified GSS failure. Minor code may provide more information GSSAPI continuation error: Server not found in Kerberos database # Trying different combinations here # Kerberos and GSSAPI #krb_server_keyfile = '' krb_server_keyfile = '/tmp/' krb_srvname = 'postgres'# (Kerberos only) #krb_srvname = 'AD.DOMAIN.COM' # (Kerberos only) #krb_caseins_users = off krb_caseins_users = on $ ./configure --prefix=/usr/local/pgsql.v901 --with-includes=/usr/local/include:/usr/local/ssl/include:/usr/local/krb/include:/usr/local/python-2.5.2/include --with-libraries=/usr/local/lib:/usr/local/ssl/lib:/usr/local/krb/lib:/usr/local/python-2.5.2/lib --with-perl --with-gssapi --with-python --with-openssl --with-libxml --enable-thread-safety
Re: [ADMIN] COPY statement for linux server from windows client
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 and choosing a path I get the error relative path not allowed for COPY to file. Is there any way of solving this on server side or I have to fight it in app's code? Hi, you have to use absolute path for COPY TO, is that any problem with that? regards Szymon
Re: [ADMIN] failing to compile v. 9.0.1 on debian squeeze with readline
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 `process_postgres_switches': postgres.c:(.text+0x122b): undefined reference to `optreset' utils/misc/ps_status.o: In function `set_ps_display': ps_status.c:(.text+0xd6): undefined reference to `setproctitle' collect2: ld returned 1 exit status make[2]: *** [postgres] Error 1 make[2]: Leaving directory `/opt/postgres/tmp/postgresql-9.0.1/src/backend' make[1]: *** [all] Error 2 make[1]: Leaving directory `/opt/postgres/tmp/postgresql-9.0.1/src' make: *** [all] Error 2 A workaround seems to ./configure with '--without-readline' (and the above mentioned parameter values get st to 'no') but I would like to ask 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\* -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
[ADMIN] monitor SQL activity in db
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 -- --- Isabella A. Ghiurea isabella.ghiu...@nrc-cnrc.gc.ca Canadian Astronomy Data Centre |http://www.nrc-cnrc.gc.ca/eng/services/hia/data-centre.html National Research Council of Canada, Herzberg Institute of Astrophysics 5071 West Saanich Road, Victoria BC V9E 2E7, Canada Phone: 250 363-3446 fax: 250 363-0045 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
Re: [ADMIN] failing to compile v. 9.0.1 on debian squeeze with readline
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 place), now i have # dpkg -l \*readline\* ... un libreadline-commonnone(no description available) un libreadline-dev none(no description available) un libreadline4 none(no description available) ii libreadline5 5.2-7 GNU readline and history libraries, run-time libraries un libreadline5-dev none(no description available) ii libreadline6 6.1-3 GNU readline and history libraries, run-time libraries ii libreadline6-dev 6.1-3 GNU readline and history libraries, development files un libterm-readline-gnu-perl none(no description available) un libterm-readline-perl-perlnone(no description available) ii readline-common 6.1-3 GNU readline and history libraries, common files un tclreadline none(no description available) Just for the record, for some reason saying # apt-get build-dep postgrsql-8.4 (it doesnt install any libreadline*-dev as dependency) # apt-get source postgresql-8.4 # dpkg-buildpackage -rfakeroot succeeds but on that system it fails compiling from source. I must admit that i dont know that much about using computers to discuss it further whether it is bad or good thing that i need to install manually libreadline6-dev to compile from source. Now i am content with being able to compile PostgreSQL from source on Squeeze and thanks for your replies. Imre -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
Re: [ADMIN] pg_* Tables
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 getting high sequential scans for some pg_* tables: database=# select relname, sum(seq_scan) as seq_scan,sum(seq_tup_read) as seq_tup_read,sum(idx_scan) as idx_scan, sum(idx_tup_fetch) as idx_tup_fetch, sum(n_tup_ins) as n_tup_ins, sum(n_tup_upd) as n_tup_upd, sum(n_tup_del) as n_tup_del from pg_stat_all_tables group by 1 order by 2 desc limit 4; relname | seq_scan | seq_tup_read | idx_scan | idx_tup_fetch | n_tup_ins | n_tup_upd | n_tup_del -+--+--+--+---+---+---+--- table | 6896498 | 91295702 | 107663 |469057 |103966 | 103966 |103966 pg_authid | 3119053 |125950392 | 12000732 | 12000718 | 1 | 1 | 0 pg_am | 2642438 | 2642440 |5 | 5 | 0 | 0 | 0 pg_database | 1349020 | 14771768 | 6953392 | 6953392 | 0 | 0 | 0 ... Is this normal? Is it advisable to index pg_* tables? Do you vacuum the database regularly ? What are the number of rows in those tables ? It is possible that the planner is doing a sequential scan because the tables are small and that's faster than doing indexed reads. Greg Williamson