Re: [ADMIN] Can't connect to PGSQL

did you start your databases with the -i option (enable TCP/IP connections) if so, you may have a firewall or something disable port 5432 When you start your databases, how do you do so? like: /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data -i >/log/logfile-`date +"%d-%m-%y"` 2>&1 for post

Re: [ADMIN] Linux system panic

I think there's something not-so-good with your system... and it looks like it is the memory... What kind of system do you have? (processor, diskspace, memory etc...) How much of the memory is taken before you begin your transaction, and how much during the transaction... "Greg Spiegelberg" <[EMAI

Re: [ADMIN] joins

On Mon, Nov 04, 2002 at 14:37:42 -0500, Jodi Kanter <[EMAIL PROTECTED]> wrote: > Can anyone tell me if there is any real difference between the two different ways to >create tables joins? > > select field1, field2 from table1 join table2 using (field3) > > vs. > > select field1, field2 from t

Re: [ADMIN] Bug in psql's "-R" option?

OK, sorry for the muddle-headed post (I realized my error as I walked away from my desk ...). The bug seems to be in the copy from parsing, which does not follow the documentation as I related in my original message. -Original Message- From: Bruce Momjian [mailto:pgman@;candle.pha.pa.us]

Re: [ADMIN] Bug in psql's "-R" option?

psql -R controls the record separator for query output, not COPY. --- Murthy Kambhampaty wrote: > There seems to be a bug in psql's -R option (and the -P recordsep= ) > version. I find that whereas the following succeeds: >

[ADMIN] Bug in psql's "-R" option?

There seems to be a bug in psql's -R option (and the -P recordsep= ) version. I find that whereas the following succeeds: /usr/local/pgsql/bin/psql -U -d -h \ -P format=unaligned -P fieldsep='\t' -P tuples_only \ -c "select * from tab where yoo='hoo'" | /usr/local/pg

Re: [ADMIN] loading and unloading rows

As long as you are going to use pipes to do your "load/unload" or "read from one cluster, copy to another", why not go with: /usr/local/pgsql/bin/psql -U -d -h \ -P format=unaligned -P fieldsep='\t' -P tuples_only \ -c "select * from tab where yoo='hoo'" | /usr/local

Re: Fw: [ADMIN] joins

There's no technical reason why you can't do development this way, just make sure that each development site has access to the database (via pg_hba.conf) and perhaps the server as well (to view log output and such) Robert Treat > - Original Message - > From: tachung_h

Re: [ADMIN] Logging RAISE statement to a logfile aside from syslog

On Mon, 2002-11-04 at 01:29, Ludwig Lim wrote: > Hi: > >Is there a way of logging the RAISE statements in a > plpgsql function to a logfile (aside from syslog)? I > noticed that all RAISE statments are only logged in > the syslog. > I dont think there is any way to get just the RAISE stateme

Re: [ADMIN] About lower and uppercase

Thanks!!! I use ilike and I get the result that I want... Thanks! Regards! Original Message: - From: Stephan Szabo [EMAIL PROTECTED] Date: Mon, 04 Nov 2002 21:50:06 -0800 (PST) To: [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: [ADMIN] About lower and u

Re: [ADMIN] About lower and uppercase

Thanks!!! I use ilike and I get the result that I want... Thanks! Regards! Original Message: - From: Stephan Szabo [EMAIL PROTECTED] Date: Mon, 04 Nov 2002 21:50:06 -0800 (PST) To: [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: [ADMIN] About lower and u

Re: [ADMIN] dumping a password-protected db from a perl script or

How can i dump a password-protected database using perl (DBI or pg) or C (using libpq)? I can't pass the password to pg_dump utility (I was trying to pass it via tty also) when running system() from perl. Isn't example below something like what you are trying to do: 8< #include #incl