Re: [ADMIN] Question about DB VACUUM

2003-10-08 Thread Chris White (cjwhite)
BTW, the connection I shutdown, had not read, written or deleted any large objects. It had read and written to other tables. This is causing me concern as I am using a thread pool to provide access to the data in the large object table, and this seems to imply I have to close each connection after

Re: [ADMIN] Pgsql crashes frequently

2003-10-08 Thread Ganesan Kanavathy
Title: Message When I check the logfile it is stated there:"pcMemoryCreate: shmget(key=5432001, size=1466368, 03600) failed: Invalid argumentThis error usually means that PostgreSQL's request for a shared memory segment exceeded your kernel's SHMMAX parameter. You can either reduce the

[ADMIN] Installing plpgsql fails

2003-10-08 Thread Nigel Bishop
Hi Solaris 8 PG V7.3.3 I'm trying to install the procedural language plpgsql using: createlang plpgsql securnet But this fails with: ERROR: stat failed on file '$libdir/plpgsql': No such file or directory createlang: language installation failed pg_config --libdir - returns:

Re: [ADMIN] Installing plpgsql fails

2003-10-08 Thread Andreas Schmitz
Hi, edit the script called createlang and adjust PGLIB='$libdir'. regards -Andreas On Wednesday 08 October 2003 13:19, Nigel Bishop wrote: Hi Solaris 8 PG V7.3.3 I'm trying to install the procedural language plpgsql using: createlang plpgsql securnet But this fails with: ERROR:

[ADMIN] unsubscribe

2003-10-08 Thread Héctor A. Albospino
unsubscribe psql-admin Fondo de Gráficos circulares.jpg

[ADMIN] Upgrade questions - backup OIDs? Upgrade pg_dumpall first? Tips?

2003-10-08 Thread Jeff Harr
Hi all, I'm about to upgrade from 7.1.3 to 7.3.2, and I'm going through the upgrade document right now. Since I'm not a DBA - I'm just a sys-admin - I'm not really sure what to make of the following option during the backup part of the upgrade: "If you need to preserve OIDs (such as when

Re: [ADMIN] Pgsql crashes frequently

2003-10-08 Thread scott.marlowe
this page should have the information you need to fix that problem: http://www.postgresql.org/docs/7.3/static/kernel-resources.html Let me know if that doesn't take care of the issue. On Wed, 8 Oct 2003, Ganesan Kanavathy wrote: When I check the logfile it is stated there: pcMemoryCreate:

Re: [ADMIN] Upgrade questions - backup OIDs? Upgrade pg_dumpall

2003-10-08 Thread Oliver Elphick
On Wed, 2003-10-08 at 16:25, Jeff Harr wrote: Hi all, I'm about to upgrade from 7.1.3 to 7.3.2, and I'm going through the upgrade document right now. Since I'm not a DBA - I'm just a sys-admin - I'm not really sure what to make of the following option during the backup part of the upgrade:

Re: [ADMIN] Question about DB VACUUM

2003-10-08 Thread Christopher Browne
In the last exciting episode, [EMAIL PROTECTED] (Chris White (cjwhite)) wrote: BTW, the connection I shutdown, had not read, written or deleted any large objects. It had read and written to other tables. This is causing me concern as I am using a thread pool to provide access to the data in

Re: [ADMIN] Question about DB VACUUM

2003-10-08 Thread Chris White (cjwhite)
Sorry to be such a pain on this, but we are running postgres on a system where we are using a 512MB compact flash as our physical disk media, so disk space usage is of utmost importance. Chris -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Christopher

Re: [ADMIN] Installing plpgsql fails

2003-10-08 Thread Tom Lane
Nigel Bishop [EMAIL PROTECTED] writes: ERROR: stat failed on file '$libdir/plpgsql': No such file or directory createlang: language installation failed pg_config --libdir - returns: I think the pg_config setting you need to look at is --pkglibdir. regards, tom lane

[ADMIN] I don't want more mails

2003-10-08 Thread lgama
Dear PostgreSql staff I've been recieving a lot of emails about PostgreSql administration, and I don't want reciving it anymore, remove my account from your databases records, please. Thanks a lot. M.C. Luis Antonio Gama Moreno Estudiante de Doctorado Centro de Investigación en Computación

Re: [ADMIN] I don't want more mails

2003-10-08 Thread email
Try this link: http://webmail.postgresql.org/mj/mj_wwwusr/domain=postgresql.org?user=passw=func=show You may have to obtain your password before you can sign in and change your subscription. HTH, sincerely, Jürgen Cappel lgama [EMAIL PROTECTED] schrieb am 08.10.2003, 12:35:47: Dear

[ADMIN] Problem with the pq_recvbuf

2003-10-08 Thread shyamperi
4:12p Dear all, I am facing problems with the postgres(7.3.1) on windows machine(98). The problem is with pg_recvbuf. And here are the logs.. Can any one teach me more on this LOG: pq_recvbuf: unexpected EOF on client connection LOG: pq_recvbuf: unexpected EOF on client connection LOG: