Re: In need of Perl/PostgreSQL tutorials

There are a couple of good books out now on PostgreSQL. They should be able to get you started with PostgreSQL. Of course, there is also extensive documentation on the PostgreSQL website, including a programmer's manual (it, alas, does not have any Perl code, but the Pg.pm module very closesly follows the libpq C library).

-- Brett

Go not to the Elves for counsel, for they will say both no and yes

Comment on Re: In need of Perl/PostgreSQL tutorials

Replies are listed 'Best First'.
Re: In need of Perl/PostgreSQL tutorials by dustbuster (Novice) on Dec 10, 2001 at 09:03 UTC
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.	[reply]
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]


Just another Perl shrine
	PerlMonks