Recent Posts by mpugsley

Topic: WAPPStack / pgpass in WAPP?

That worked! Thank you, Carlos!

Although I haven’t tried it yet, I bet that I could also set an environment variable for PGPASSFILE which specifies the location of .pgpass and then create my own .pgpass. I thought about the PGPASSFILE setting earlier, but I kept looking in the postgresql.conf file for it (which I would then alter). But I never saw it there, and I didn’t think to create an environment variable.

And FYI for anyone else who needs this solution, this worked for a WindowsXP box.

Thanks again!

Topic: WAPPStack / pgpass in WAPP?

With Postgres installed from the Postgres site, a file .pgpass exists in order to control ‘auto’ lookups of passwords. That’s how you can connect without supplying a password.

I’ve noticed that I can login with postgres and not supply a password, but now that I’ve changed my password, the wrong password is being automatically supplied. How do I change this since I do not see a .pgpass file anywhere on my computer?

I can correctly connect if I use the -W paramter with psql. But that forces me to answer a prompt. The only way I know to run a script without answering a prompt is to automatically supply a password. I don’t think Postgres has anything like a -ppassword switch.

Thanks,
Matt Pugsley

Topic: WAPPStack / how to change listen port for postgres?

I, um, found the file (hides head sheepishly). postgresql.conf is in the data subdirectory of the postgresql directory within the BitName WAPPStack directory. The conf file explains how to set the listen address to whatever you need. It can be a comma separated list if you want several addresses.

Topic: WAPPStack / how to change listen port for postgres?

I have installed WAPP and everything works well, but I am presently unable to configure Postgres (or Apache) to listen to any ip other than 127.0.0.1. I would like to be able to use my network address, but I don’t see the usual configuration file (postgres.conf).

I see httpd.conf for Apache, but (a) I don’t think that would have anything to do with Postgres, even if these are integrated services and (b) httpd.conf says “Listen 80”, which I believe listens to all bound ips addresses. It therefore should be bound to my network address (although my webserver doesn’t seem to be working on anything other than 127.0.0.1).

I see a properties.ini file in the WAPP Stack main directory, but that doesn’t provide any ‘dummy’ ip settings that I could change. If I’m supposed to add an ip setting, I don’t know what it would be the appropriate variable would be named.

All help is much appreciated!