[ADMIN] Unclosed connections

2008-01-25 Thread PostgreSQL Admin
We are using this bad piece of the software that does not close connections to the postgres server. Is there some setting for closing dead connections? And not TCP/IP keep alive does not work. ---(end of broadcast)--- TIP 6: explain analyze is yo

Re: [ADMIN] how to create a limited user

2008-01-22 Thread PostgreSQL Admin
Did you even look for the information on postgresql.org? http://www.postgresql.org/docs/8.2/interactive/sql-createuser.html ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [ADMIN] deinstallation - reinstallation on Mac OS 10.4

2007-07-26 Thread PostgreSQL Admin
I hate to sound like a --- but did you read the README on starting the server? You start the server by using the postmaster command: /path/to/postmaster -D /path/to/data look at the postgresql manual - it's all there. J ---(end of broadcast)-

Re: [ADMIN] deinstallation - reinstallation on Mac OS 10.4

2007-07-24 Thread PostgreSQL Admin
run this in the command line locate postmaster.pid or find / -name "postmaster.pid" -print that should locate any postmaster files and then remove whatever looks like the postmaster.pif file ---(end of broadcast)--- TIP 2: Don't 'kill -9' the po

[ADMIN] pgmemcache

2007-07-18 Thread PostgreSQL Admin
As anyone used pgmemcache? I would like to look more into a but I'm having problems installing the sql. I'm on OS X 10.4 and the sql there are lines causing errors: (e.g. AS '$libdir/pgmemcache', 'memcache_server_add' LANGUAGE 'C' STRICT;) thanks for any input and also will version 1.2 come

[ADMIN] UTF8 characters

2006-07-21 Thread PostgreSQL Admin
I had my database set to SQL_ASCII and switched to UTF8, but now I notice that I must add a slash for periods/dots ( \. vs . ) to insert into varchar. Is this normal? Thanks, J ---(end of broadcast)--- TIP 5: don't forget to increase your free spa