Re: In need of Perl/PostgreSQL tutorials

I really appreciate all the advice but I must be moving the project along. I realize that PG.pm is not very portable but as I said before I am new and will certainly need to rewrite some of my source code anyway. This is an educational project that address databases and the web.

Since I have you all here perhaps someone can help me with this:

I was logged in as root and tried to create a new user for my Postgres database and recieved this:

# createuser mydatabase
Connection to database 'template1' failed.
fe_sendauth: no password supplied

Can anyone help me with this error. On my local machine I can create users without hassle.

Thanx, D.

Comment on Re: In need of Perl/PostgreSQL tutorials

Replies are listed 'Best First'.
Re: Re: In need of Perl/PostgreSQL tutorials by Ryszard (Priest) on Dec 10, 2001 at 09:43 UTC
Create a "postgres" user, and set up all the environment variables such as PATH, and LD_LIBRARY_PATH, then run createuser this way. Make sure postmaster is not running as root. In fact i think postgres checks to see if a root account is trying to run it, and wont allow it. It's pretty easy to whip up a script to execute postgres at startup as well, and saves starting it manually each time. If youre using it for a web application, can i also recommend using the CGI::Application/HTML::Template framework. It provides a nice structur for the applications you write. I guess down the track you'd want to look at mod_perl as well. It loads everything into memory, so your script only has to load once, not every time its called.	[reply]

Replies are listed 'Best First'.

Re: Re: In need of Perl/PostgreSQL tutorials
by Ryszard (Priest) on Dec 10, 2001 at 09:43 UTC

Create a "postgres" user, and set up all the environment variables such as PATH, and LD_LIBRARY_PATH, then run createuser this way.

Make sure postmaster is not running as root. In fact i think postgres checks to see if a root account is trying to run it, and wont allow it.

It's pretty easy to whip up a script to execute postgres at startup as well, and saves starting it manually each time.

If youre using it for a web application, can i also recommend using the CGI::Application/HTML::Template framework. It provides a nice structur for the applications you write. I guess down the track you'd want to look at mod_perl as well. It loads everything into memory, so your script only has to load once, not every time its called.

[reply]