http://qs1969.pair.com?node_id=130601


in reply to 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]

      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]

In Section Seekers of Perl Wisdom