Beefy Boxes and Bandwidth Generously Provided by pair Networks
Just another Perl shrine

Re: In need of Perl/PostgreSQL tutorials

by bmccoy (Beadle)
on Dec 10, 2001 at 08:40 UTC ( #130601=note: print w/replies, xml ) Need Help??

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 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 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.

      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.

Log In?

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://130601]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others lurking in the Monastery: (5)
As of 2023-06-06 13:00 GMT
Find Nodes?
    Voting Booth?
    How often do you go to conferences?

    Results (26 votes). Check out past polls.