trust
host all my_ip 255.255.255.255 trust
where my_ip is an IP address
May be I have a probleme with my system ?
version of the kernel is 2.4
jean-arthur
At 18:55 24/06/02 -0400, Tom Lane wrote:
>Jean-Arthur Silve <[EMAIL PROTECTED]> writes:
> > I have a httpd
Hi !
I have a httpd server on one server, and PostgresQL 7.2 on a second server
(P4 1.7 Ghz / Linux ) on a local network.
When there are about 20 (and more ) connection on the DB, the remote
connecxtion to the DB from the web server is very long (about 5-10 sec)
before have the prompt.
On th
Hello !
I used to run vacuum verbose analyze (vacuumdb -v -a -z) every days.
Everything was ok for months until yesterday !
Usually, this command takes about 1 mn.
Now, vacuum "blocks" on one table (apparently "comptes" table) , without HD
activity, no error message
avr 15 10:31:27 uranus
Hello !
I used to run vacuum verbose analyze (vacuumdb -v -a -z) every days.
Everything was ok for months until yesterday !
Usually, this command takes about 1 mn.
Now, vacuum "blocks" on one table (apparently "comptes" table) , without HD
activity, no error message
avr 15 10:31:27 uranus
Hello !
I used to run vacuum verbose analyze (vacuumdb -v -a -z) every days.
Everything was ok for months until yesterday !
Usually, this command takes about 1 mn.
Now, vacuum "blocks" on one table (apparently "comptes" table) , without HD
activity, no error message
avr 15 10:31:27 uranus
I tried, but nothing has changed !
The strangest is I have a database which was not accessed sinc several days
and even this one does not function
in pg_class, I see for exemple that one on my table has ntuples=1800 but
I can't access it...
Well...I really dont know this time what to do..
At 14:12 12/02/01 +0100, Jean-Arthur Silve wrote:
>Hi !
>
>I did a pgdump on a database. It was ok
>
>After, all tables have dissapeard ,even those in other databases !
>
>when I check in the data directories, all datas are here, but in pg_class,
>there is no more t
At 14:12 12/02/01 +0100, Jean-Arthur Silve wrote:
>Hi !
>
>I did a pgdump on a database. It was ok
>
>After, all tables have dissapeard ,even those in other databases !
>
>when I check in the data directories, all datas are here, but in pg_class,
>there is no more t
Hi !
I did a pgdump on a database. It was ok
After, all tables have dissapeard ,even those in other databases !
when I check in the data directories, all datas are here, but in pg_class,
there is no more tables ! (except system tables !)
Is there a way to retrieve my lost tables ?
jean-a
It s strange :
I can do a "SELECT.." on my tables : return 0 rows (but there is 1000 rows !!!)
but when i do "\d", it says "couldn't find any tables"...
any idea ???
At 10:11 12/02/01 +0100, Jean-Arthur Silve wrote:
>Hi !
>
>I did a pgdump on a d
Hi !
I did a pgdump on a database. It was ok
After, all tables have dissapeard ,even those in other databases !
when I check in the data directories, all datas are here, but in pg_class,
there is no more tables ! (except system tables !)
Is there a way to retrieve my lost tables ?
jean-a
Hello,
I would like that the option ENABLE_SEQSCAN be OFF by default, without to
have enter this statment at each session.
(SET ENABLE_SEQSCAN=OFF)
Is there an environment variable to set or something like that ??
thank you !
jean-arthur
Hello !
I use POSTGRES 6.4...
Everuthing was working ok for months, but since 3 days, I have sometimes
when my PHP scrits try to connect :
Warning: Unable to connect to PostgresSQL server: connectDB():
getprotobyname failed in /opt/htdocs/html/php/atos_lib.phtml on line 3
Have you any idea
Hello !
I use POSTGRES 6.4...
Everuthing was working ok for months, but since 3 days, I have sometimes
when my PHP scrits try to connect :
Warning: Unable to connect to PostgresSQL server: connectDB():
getprotobyname failed in /opt/htdocs/html/php/atos_lib.phtml on line 3
Have you any idea
Thanks for your help
pg_exec($dbh, "set enable_seqscan off;");
seems resolve my problem...
I look at the docs, but I didn't understand very well what is the use of
this variable ?
thank you !
jean-arthur
At 01:25 06/12/00 -0800, Alfred Perlstein wrote:
>* Jean-Arthur Silve
Hello,
I have a problem :
it seems that when a script access to a db for a SELECT (or table i don't
really know), postgres locks the db or table and other scripts cannot
access to this DB concurrently.
So it's very very slow when this script (a PHP4 script) is called by
several users...
it's s
16 matches
Mail list logo
