Hope there's somebody with postgres experience. I just won't get it. So here are my questions. Hope you can answer them. I initialized postgres as described on the cobalt site. Now i have two databases there. Cobalt and template1.
Which one do i have to use to create one database (DB1). Then i want to create a user (USER1). I want to give user1 ONLY access to his database without more rights but letting him do with his db whatever he likes (only on localhost, no external connections).
Then i installed a central copy of PGadmin. How do i create a user which has the right to connect to the database (which? cobalt/template1?) and read the databases to authentify the user? Just like in phpMyAdmin. I would like to know the exactly shell commands to do this. I've read through the cobalt-users mailing list and marc's archives without finding more detailed info. :confused:
Please help, i have a client which needs a postgres database immiadiately (within 12 hours). Thx

Hmm, anyone? I can't believe that nobody in these forums has a clue what i am talking about. :rolleyes:

I think most members use MySQL over postgres and this is why you are having a tough time here. Maybe there is a postgres user mailing-list? Or try the cobalt mailing-list?

I tried and finally i have set it up, but NOT the way it SHOULD be :(
This postgres thingy really pi$$es me off. One of the most difficult databases i ever dealt with. I looked everywhere, subscribed to every possible list. It's all very confusing for a postgres newbie but i guess that once you've got the start it won't be very difficult.
Anyway, any help STILL welcome.

Can't believe it but I set it up!!! :D
Wasn't so hard after all. Just the start was difficult. :rolleyes:

Excellent! Now we have a member to answer the next question on PostgreSQL! :D

Originally posted by Lawrence
Excellent! Now we have a member to answer the next question on PostgreSQL! :D

:D

Another question about DBD:PG

This is what it says in the Makefile.PL
use ExtUtils::MakeMaker;
use Config;
use strict;
use DBI 1.00;
use DBI::DBD;

print "Configuring Pg\n";
print "Remember to actually read the README file !\n";

my $POSTGRES_INCLUDE;
my $POSTGRES_LIB;

if ((!$ENV{POSTGRES_INCLUDE} or !$ENV{POSTGRES_LIB}) and !$ENV{POSTGRES_HOME}) {
die "please set environment variables POSTGRES_INCLUDE and POSTGRES_LIB !\n";
} elsif ((!$ENV{POSTGRES_INCLUDE} or !$ENV{POSTGRES_LIB}) and $ENV{POSTGRES_HOME}) {
$POSTGRES_INCLUDE = "$ENV{POSTGRES_HOME}/include";
$POSTGRES_LIB = "$ENV{POSTGRES_HOME}/lib";
} else {
$POSTGRES_INCLUDE = "$ENV{POSTGRES_INCLUDE}";
$POSTGRES_LIB = "$ENV{POSTGRES_LIB}";
}

my $os = $^O;
print "OS: $os\n";

my $dbi_arch_dir;
if ($os eq 'MSWin32') {
$dbi_arch_dir = "\$(INSTALLSITEARCH)/auto/DBI";
} else {
$dbi_arch_dir = dbd_dbi_arch_dir();
}

my %opts = (
NAME => 'DBD::Pg',



If i don't configure anything and run perl Makefile.PL it dies saying
"Configuring Pg
Remember to actually read the README file !
please set environment variables POSTGRES_INCLUDE and POSTGRES_LIB !"
How do i find out these environment variables and how can i set them to compile DBD:PG ?