Well...
I tried to connect with psql -h 127.0.0.1 mydb and it's slow (+/- 5 sec.)
and psql mydb is fast ( less than 1 sec.) !
Here is my pg_hba :
.. few comments...
local all trust
host all 127.0.0.1 255.255.255.255trust
Jean-Arthur Silve [EMAIL PROTECTED] writes:
I tried to connect with psql -h 127.0.0.1 mydb and it's slow (+/- 5 sec.)
and psql mydb is fast ( less than 1 sec.) !
Here is my pg_hba :
local all trust
host all 127.0.0.1
On Sun, 30 Jun 2002 23:21:24 +0400 (MSD)
Dmitry Morozovsky [EMAIL PROTECTED] wrote:
I suppose it would be very useful if you place some links to Dia-related
pages to your page. Especially for BDA-newbies, you know ;-)
Done. Added links to Dia, Postgres, and Schemamania. Didn't bother adding
Is there a way to rename an existing database, short of dumping and
restoring it?
--
Florian Weimer[EMAIL PROTECTED]
University of Stuttgart http://CERT.Uni-Stuttgart.DE/people/fw/
RUS-CERT fax +49-711-685-5898
Florian Weimer [EMAIL PROTECTED] writes:
Is there a way to rename an existing database, short of dumping and
restoring it?
In 7.1 or later a quick UPDATE on pg_database.datname should do it,
I believe.
It might be a bad idea to do it while there are any connections to
the target database ---
I have a cgi script written in C++ and compiled with libpq++. The script attempts to
connect to a postgresql database but fails, although I can connect to the database on
the command line. I'm wondering if there is an error log somewhere that I can access
that would give me more information
Mark -
A few random thoughts-
When we installed Apache, the user it ran under by default was www-data.
Are you sure it is running using apache?
Have you tried doing a network connection with your apache user? (su -
apache; psql -h localhost group3.)
Log file locations may vary by OS flavor,
Because, on error:
Too many clients already.
Regards,
Robson