[ADMIN] postmaster settings

2000-05-14 Thread LeSI
Im using postgresql 6.5.3 now and its works great. but i have a problem , and i dont know if this problem is because postgresql or postmaster. Im hosting a site made in php4 . the site works with 4 databases of postgres and all works great , but the Proccesses of postmaster , never close down , a

[ADMIN] The pgsql adventure... help me!

2000-05-14 Thread Can-Host Networks - Félix C.Courtemanche
Hello again,   I finally managed to find the password for pgsql and I am now able to connect in... only to see that: 1- the table files themselves are in the right directory (ther eis a file&table named vsite for example) 2- I cant access them through pgsql.  I get an error telling me the ta

[ADMIN] Problems with PostgreSQL

2000-05-14 Thread Can-Host Networks - Félix C.Courtemanche
Hello everyone, I had some problems with postmaster but finally fixed it. Now, when I try to connect to psql, i can't seejm to find the good password. (The db was already installed when we got this box, so we have no idea what it is) Is there any way to retreive it or something? We are running

Re: [ADMIN] Problems with PostgreSQL

2000-05-14 Thread Can-Host Networks - Félix C.Courtemanche
Thank you for the fast answers. In the mean time I discovered another problem between MySQL's dbd and PgSQL's. I removed that and verified every permission on the needed files and finally had PgSQL back up... Now, for some _odd_ reasons, ALL the databases disapeared. At least I have postmaster

Re: [ADMIN] Problems with PostgreSQL

2000-05-14 Thread Len Morgan
I would check two things right away: 1. Is the Postmaster running (ps ax | grep postmaster) and is it accepting IP connections (i.e., not just UNIX socket connections)? This is shown by the -i option you should see in the ps command. You did not mention the version of Postgresql/RPM you are run