Using a postgresql database help please!
![](https://seccdn.libravatar.org/avatar/1503598082c617ca44baa574652f2248.jpg?s=120&d=mm&r=g)
Hello all, I have a program called muwed and it is a php script that works in Apache to share mp3's or just to use locally with irmp3. I have irmp3 working and I have apache following symlinks with no problem to my files but my problem is that I start the postgesql and it starts with no problem but when I try to do a query with this interface I get the error that it can't connect to the database. Warning: Unable to connect to PostgreSQL server: could not connect to server: Connection refused Is the server running on host XP19 and accepting TCP/IP connections on port 5432? I also try to start the postmaster and it can't find the database and gives me the error: postmaster postmaster does not know where to find the database system data. You must specify the directory that contains the database system either by specifying the -D invocation option or by setting the PGDATA environment variable. Now the questions: 1. Where the hell is this Db located? I can't find that anywhere on my system? It was created with a script from the program and I know its somewhere because I tried to create again and I got an already exists error. 2. What do I have to put where to get this thing to work and connect locally to use the Db? I think it has something to do with the postmaster but I don't know for sure. 3. How can I configure Apache to only accept local connections? I'm using SuSE 8.0 with the default config. Thanks in advance for any help, Scott
![](https://seccdn.libravatar.org/avatar/674268099a944713b6d269ee01c07313.jpg?s=120&d=mm&r=g)
Hello Scott Few tips that might help you sort out your problem. When you try to start postmaster, how do you try to start it? As you are using Suse, try starting it as root: /etc/rc.d/postgres start You can try checking whether postmaster is really running by: ps aux|grep postmaster Do you get any rows that has postmaster mentioned in it? If so, postmaster is running ok. Have you shut down you machine brutally ;-) If so, check and remove /tmp/.s.PGSQL.* and as postgres user (as root: "su - postgres") ~/postmaster.pid Then try starting postmaster again. You can try stopping starting it as user "postgres" by: pg_ctl stop pg_ctl -o "-Si" start If you still encounter problems, mail to the list and we have sorted somehow :-) --Jyry C:-( C:-/ C========8-O C8-/ C:-( On 26 Jun 2002, Scott Nichols wrote:
Hello all, I have a program called muwed and it is a php script that works in Apache to share mp3's or just to use locally with irmp3. I have irmp3 working and I have apache following symlinks with no problem to my files but my problem is that I start the postgesql and it starts with no problem but when I try to do a query with this interface I get the error that it can't connect to the database. Warning: Unable to connect to PostgreSQL server: could not connect to server: Connection refused Is the server running on host XP19 and accepting TCP/IP connections on port 5432?
I also try to start the postmaster and it can't find the database and gives me the error: postmaster postmaster does not know where to find the database system data. You must specify the directory that contains the database system either by specifying the -D invocation option or by setting the PGDATA environment variable.
Now the questions:
1. Where the hell is this Db located? I can't find that anywhere on my system? It was created with a script from the program and I know its somewhere because I tried to create again and I got an already exists error. 2. What do I have to put where to get this thing to work and connect locally to use the Db? I think it has something to do with the postmaster but I don't know for sure. 3. How can I configure Apache to only accept local connections?
I'm using SuSE 8.0 with the default config.
Thanks in advance for any help,
Scott
-- To unsubscribe send e-mail to suse-linux-e-unsubscribe@suse.com For additional commands send e-mail to suse-linux-e-help@suse.com Also check the archives at http://lists.suse.com
participants (2)
-
Jyry Kuukkanen
-
Scott Nichols