[GENERAL] Keeping postmaster running or restarting

1999-10-01 Thread Doran L. Barton
If I can't control this, how can I detect crashes like this and restart the postmaster quickly? -+Fozz -- Doran L. Barton <[EMAIL PROTECTED]> Iodynamics LLC -- "Internetworking the masses" http://www.iodynamics.com/>

Re: [GENERAL] How to import data from MDB or pipe delimited file into PostgreSQL

1999-10-01 Thread Doran L. Barton
probably still have to do that by hand. -=Fozz -- Doran L. Barton <[EMAIL PROTECTED]> Iodynamics LLC -- "Internetworking the masses" http://www.iodynamics.com/>

Re: [GENERAL] 6.5.2 patch

1999-10-03 Thread Doran L. Barton
t when developers fail to read the messages they reply to. :-) You use the 'patch' command to apply the patch after it is gunzip'd. cd /usr/local/src/postgreql-6.5.2 patch -p0 /path/to/patchfile -=Fozz -- Doran L. Barton <[EMAIL PROTECTED]> Iodynamics LLC -- "Internetworking the masses" http://www.iodynamics.com/>

Re: [GENERAL] problem compiling pgsql 6.5.1 on SuSE 6.2

1999-10-03 Thread Doran L. Barton
ion numbers of the OS, compiler, compiler library (e.g. glibc) etc. If you're using Linux, please indicate the distribution and version. -=Fozz -- Doran L. Barton <[EMAIL PROTECTED]> Iodynamics LLC -- "Internetworking the masses" http://www.iodynamics.com/>

Re: [GENERAL] problem compiling pgsql 6.5.1 on SuSE 6.2

1999-10-03 Thread Doran L. Barton
Not long ago, [EMAIL PROTECTED] proclaimed... > I found this problem while compiling 6.5.1: Woops. A half second after I sent my previous reply, I noticed the information I was looking for in the subject line. :-) -- Doran L. Barton <[EMAIL PROTECTED]> Iodynamics LLC -- "Inter

Re: [GENERAL] get the list of databases

1999-10-05 Thread Doran L. Barton
ssue the following SQL query: SELECT * FROM PG_DATABASE; Enjoy. -- Doran L. Barton <[EMAIL PROTECTED]> Iodynamics LLC -- "Internetworking the masses" http://www.iodynamics.com/>

Re: [GENERAL] Again: How the hell do I restart immediately

1999-10-08 Thread Doran L. Barton
/bin/sh > > while : > do > postmaster >> post.out 2>&1 > done One problem I see with solutions like this is that they disregard the socket file kept in /tmp. The postmaster will croak if that file exists when it tries to start again. Hmm. -=Fozz -- Doran L. Barton &

Re: [GENERAL] Again: How the hell do I restart immediately

1999-10-08 Thread Doran L. Barton
21:22:13 lists logger: ERROR: postmaster: StreamConnection: accept: No route to host And then... it dies. I see this message in the log every time the server has died. It was doing this under 6.4.2 and now again with 6.5.1. Again, any helpful pointers would be MUCH appreciated. -- Doran L. Barton <[EMAIL PROTECTED]> Iodynamics LLC -- "Internetworking the masses" http://www.iodynamics.com/>

Re: [GENERAL] authenification problems with win32-psql-client

1999-10-26 Thread Doran L. Barton
er machine to allow access from the Win98 machines? -+Fozz -- Doran L. Barton <[EMAIL PROTECTED]> Iodynamics LLC -- "Internetworking the masses" http://www.iodynamics.com/>

[GENERAL] Re: Search strings

1999-12-29 Thread Doran L. Barton
tring operators in PostgreSQL. One of my favorite is ~* which does a case-insensitive regular expression search. SELECT * FROM TABLE1 WHERE FIELD1 ~* 'dog'; Hope that helps. -=Fozz -- Doran L. Barton <[EMAIL PROTECTED]> Iodynamics LLC -- "Internetworking the masses" http://www.iodynamics.com/>