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

etc/rc.local, su -l _postgresql -c "nohup /usr/local/bin/pg_ctl 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' \ >/

[GENERAL] SYSCONFDIR, initdb and postgresql.conf

db put the config files 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 chan

[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 --

[GENERAL] Timestamp with time zone: why not?

ype be preferred to 'TIMESTAMP WITH TIME 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

Re: [GENERAL] PG compilation

/Python functionality in PG 8.2.1 one solution is to soft link 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 mod

[GENERAL] PG compilation

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

Re: [GENERAL] Postgres Replication

inserts with things like > now() might 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 S

[GENERAL] dynamic SQL - variable substitution in plpgsql

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

Re: [GENERAL] running external programs

e to be flagged trusted or not ? 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 datatypes do not match

[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 'ki

[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&#

Re: [GENERAL] plpython

: could not load library "/usr/local/pgsql/lib/plpython.so": /usr/local/pgsql/lib/plpython.so: undefined symbol: Py_InitModule4_64 i am on a x86_64 linux box. 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] 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

[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] 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 y

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

Re: [GENERAL] postgresql /var fill

idnt give me any package listing. ps auxww |grep postgresql gives /data/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

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

[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

[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

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 :) t

Re: [GENERAL] 8.1.4 compile problem

rom configure. > > I was in a doubt if int64,int8,uint64 and uint8 are not supported after > setting up the db. > thanks for clarifying my doubt. will proceed with gmake :) > regards, > KM let me add this too: i have compiled postgres 8.1.4 even if configure didnt detect i

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_suit

[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] 8.1.4 compile problem

tput from configure. I was in a doubt if int64,int8,uint64 and uint8 are not supported 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] 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