Re: [ADMIN] Missing Databases

Tom: Tom Lane wrote: "Frank L. Parks" <[EMAIL PROTECTED]> writes: I can see each one in psql -U x dbname and I can do a \dt to display the tables on the server. When I try to connect any other way (webmin/pgadmin/application) it can't find any dbs. Can anyone please point me in a di

Re: [ADMIN] Missing Databases

"Frank L. Parks" <[EMAIL PROTECTED]> writes: > I can see each one in psql -U x dbname and I can do a \dt to display > the tables on the server. When I try to connect any other way > (webmin/pgadmin/application) it can't find any dbs. Can anyone please > point me in a direction to find the

[ADMIN] Missing Databases

I need some help in finding my missing databases. I did as pg_dumpall of 8.x and then updated to 8.1.2 and reloaded my databases using psql -U postgres template1 < dumpfile. I can see each one in psql -U x dbname and I can do a \dt to display the tables on the server. When I try to conne

Re: [ADMIN] database replication

[EMAIL PROTECTED] ("Ciprian Hodorogea") writes: > :o="urn:schemas-microsoft-com:office:office" > xmlns:w="urn:schemas-microsoft-com:office:word" > xmlns="http://www.w3.org/TR/REC-html40";> > > Hi All,:p> > > :p>  > >   Is there a stable solution for database replication with Postgres 8.1.x?:p> Sl

Re: [ADMIN] Where is my bottleneck?

Hi Arnu,      Take a look at contrib/pg_buffers and contrib/pgstattuple also!!   Regards, Guido. (dariu)     On 1/25/06, Dario Brignardello <[EMAIL PROTECTED]> wrote: Hi, Arnu,> > The parameters related with memory usage of postgresql.conf all are the> default values (I haven't changed any v

[ADMIN] database replication

Hi All,     Is there a stable solution for database replication with Postgres 8.1.x?   Thanks   Best Regards   Ciprian Hodorogea IntelliSoft SRL http://www.bitsp.com/  

Re: [ADMIN] Where is my bottleneck?

Hi, Arnu,> > The parameters related with memory usage of postgresql.conf all are the> default values (I haven't changed any value in the postgresql.conf file)Well, there is actually plenty of room to optimize there, I would suggest to go to   http://www.postgresql.org/docs/7.4/interactive/runtime-

[ADMIN] Problem with SSL - Server went 100% Busy - Part II

Hi there, I experienced the same problem as Alex eight months ago (reference below), but as there was no answer to his question. So I hope I have more luck: I got the error "SSL SYSCALL error: A blocking operation was interrupted by a call to WSACancelBlockingCall." which appears to end in a

Re: [ADMIN] Where is my bottleneck?

Hi John, Your post is a bit slim on information. So here are some questions: - Is all the memory used by postgres ? I'm not sure how to look at that (how could I do it?). Here you are the result of a top SD22-SINER5:~# top top - 15:09:50 up 453 days, 11:47, 3 users, load average: 4.08,

Re: [ADMIN] psql copy script

Don't you have to use a "\" in front of copy like : \copy? I use \copy command all the time, never have any problems with it. Yantao Shi [EMAIL PROTECTED] wrote: Hi Alvaro Thanks for the help but it does not work. when I execute it than I get: [test/data] su - postgres -c "psql logdb -c 'co

[ADMIN] psql copy script

Title: psql copy script Hi Alvaro Thanks for the help but it does not work. when I execute it than I get: [test/data] su - postgres -c "psql logdb -c 'copy test from \'/data/log/bla\''" Unmatched '. If I correct the error than I get the following: [test/data] su - postgres -c "psql

Re: [ADMIN] Where is my bottleneck?

Hi Arnau, Poor performance on idle cpu is normally due to an I/O bottleneck. The bottleneck can be either network (unlikely but easy to check) or disk i/o. Excessive disk i/o can be caused by memory starvation or maybe you just need to move a lot of data. Adding memory will give you more cache spac