Re: [GENERAL] SYSCONFDIR, initdb and postgresql.conf

start \ -D /var/postgresql/9.0/main -l /var/postgresql/logfile \ -o '-D /var/postgresql/9.0/main' \ -o '-c config_file=/etc/postgresql/9.0/main/postgresql.conf' \ /dev/null regards, tom lane Thanks -- KM -- Sent via pgsql-general

[GENERAL] SYSCONFDIR, initdb and postgresql.conf

in the directory named by the --pgdata option. There is no directory /etc/postgresql. Should I expect this? How do I persuade postgres to put its config under /etc? Thanks -- KM -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

[GENERAL] Listen and do something daemon

Does this program already exist? $ listen-and-do --database=foo --listen-for=somenotification \ --then-do=some-script It will daemonize itself, issue a 'LISTEN somenotification' on the database foo, and on each NOTIFY will run some-script. Thanks -- KM -- Sent via pgsql-general

[GENERAL] Timestamp with time zone: why not?

ZONE'? -- KM ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] PG compilation

On Fri, Jan 12, 2007 at 11:50:19AM +0100, Albe Laurenz wrote: gmake[3]: Entering directory `/home/km/postgresql8.2.1/postgresql-8.2.1/src/pl/plpython' gcc -fPIC -Wall -Wmissing-prototypes -Wpointer-arith -Winline -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -g -fpic

Re: [GENERAL] PG compilation

the /usr/bin/python to /usr/local/bin/python2.5 but i donot want to change the default python on the system as some other programs depend on it. so i am looking for a flexibility in configuring PG that it created python modules with python2.5 only. any ideas ? regards, KM

Re: [GENERAL] Postgres Replication

be a little different, insert order might not be the same on both machines, etc... I haven't used daffodil, but have heard of it. There's also c-jdbc and a few others. what abt pgcluster ? how does it fare with SlonyI ? regards, KM ---(end of broadcast

[GENERAL] PG compilation

to be compiled in ? regards , KM ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

[GENERAL] dynamic SQL - variable substitution in plpgsql

'; - tia KM ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

[GENERAL] running external programs

Hi all, Is it possible in a PLSQL function to call an external program/script residing at /usr/bin and return the result ? are there any workarounds for this sort of a problem ? regards, KM ---(end of broadcast)--- TIP 2: Don't 'kill -9

Re: [GENERAL] running external programs

Is it possible in a PLSQL function to call an external program/script residing at /usr/bin and return the result ? No, because plsql is a trusted language. You can't run external commands from such a language. Is that a deciding criteria for a language to be flagged trusted or not ? KM

[GENERAL] postgresql and reiserfs

Hi all, Is anyone up with database features in reiserfs (reiser4) with postgresql 8.x? regards, KM ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's

[GENERAL] plpython

Hi all, Can someone hint on resources for using plpython for writing stored procedures ? I have gone thru official docs for 8.1.5 for plpythonu but its not in detail/with examples. When is plpython going to be considered safe ? any targeted version ? regards, KM

Re: [GENERAL] plpython

. couldnt comprehend the error. plpython.so is in /usr/local/pgsql/lib whats wrong? regards, KM ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

[GENERAL] schema 8.1.5

account to default to a predefined schema ? i have tried : SET search_path TO myschema; but thats temprary setting i suppose. so that when the user logis in and accesses a database via psql he should be able to land into his schema. how do i do that ? any tips ? regards, KM

[GENERAL] postgresql /var fill

increases considerably - why is this happening ? i expected more free disk space to be used in /data ! does it mean that the actual database created lies in /var instead of /data ? how do i fix it ? regards, KM ---(end of broadcast)--- TIP 2

Re: [GENERAL] postgresql /var fill

On Fri, Oct 06, 2006 at 09:38:46AM -0400, Ray Stell wrote: ls -l / maybe /data is a symlink? no /data is the label for separate SCSI disk. no symlinks !!! /var resides on /dev/sda, and /data in /dev/sdb regards, KM ---(end of broadcast

Re: [GENERAL] postgresql /var fill

/pgdata as the data dir. whats happening ? regards, KM ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [GENERAL] postgresql /var fill

Have you tried looking in /var to see what's there? find /var -type f -msize +k ya looking for files bigger than KB showed only: /var/lib/rpm/RpmPackages /var/lib/rpm/Filemd5s regards, KM ---(end of broadcast)--- TIP 9: In versions

[GENERAL] shared_buffer setting

to know how is the performance hit when we change shared_buffer value in general ? regards, KM ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your

[GENERAL] postgresql.conf shared buffers

? or is there any workaround ? tia, regards, KM ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

[GENERAL] 8.1.4 compile problem

-linux Thread model: posix gcc version 3.4.4 20050721 (Red Hat 3.4.4-2) how can i add int8,uint8,int64 and uint64 functionality into postgres ? are there any special flags that i am missing ? tia, regards, KM ---(end of broadcast)--- TIP 4: Have you

Re: [GENERAL] 8.1.4 compile problem

after setting up the db. thanks for clarifying my doubt. will proceed with gmake :) regards, KM -- ---(end of broadcast)--- TIP 6: explain analyze is your friend

[GENERAL] benchmark suite

Hi all, Is there any good benchmark suite for testing postgresql performance? i tried to work with pgbench but found pgbench source (v 8.0.x and 7.4.x) but couldnt compile with gcc ($gcc -o pgbench pgbench.8.0.x.c) postgres 8.1.4 is on AMDx86_64 platform. regards, KM

Re: [GENERAL] benchmark suite

On Fri, Sep 29, 2006 at 07:27:49PM +0530, km wrote: Is there any good benchmark suite for testing postgresql performance? I suggest looking at the excellent software provided by OSDL. http://www.osdl.org/lab_activities/kernel_testing/osdl_database_test_suite/ ya i have tried the dbt1

Re: [GENERAL] 8.1.4 compile problem

doubt. will proceed with gmake :) regards, KM let me add this too: i have compiled postgres 8.1.4 even if configure didnt detect int8,uint8,int64 and uint64. i have tried to create a test table with datattype as int64 , but it says no such datatype, same is with uint8 an uint64 datatypes

Re: [GENERAL] 8.1.4 compile problem

At the SQL level, these datatypes are named after byte sizes not bit sizes, ie, int2, int4, int8. Or you might prefer smallint, int, bigint. There are no unsigned types. regards, tom lane oh!! that makes it clear :) thanks! regards, KM