Thread: Hope it's ok to post a pgAdmin request for help in this list...

Hope it's ok to post a pgAdmin request for help in this list...

From
"Tamir Halperin"
Date:
Just installed pgAdmin II and received no errors. I can connect to a database that I created from the command prompt on
thedatabase server but I cannot create a database properly from the pgadmin II client/workstation. 

The database is created but it has a red X on the icon. Allow connections is Yes but connection status is inaccessible.
Ican create users without a problem. 


Re: Hope it's ok to post a pgAdmin request for help in this list...

From
"Tamir Halperin"
Date:
I think I diagnosed the problem to be access restrictions in the pg_hba.conf file.

I made the changes but I can't run pg_ctl reload without first setting a $PGDATA environment variable. Can someone
pleasetell me how to do this properly for PostgreSQL on my FreeBSD 4.6 system? 

> -----Original Message-----
> From: Tamir Halperin
> Sent: Saturday, March 29, 2003 3:19 AM
> To: pgsql-admin@postgresql.org
> Subject: [ADMIN] Hope it's ok to post a pgAdmin request for
> help in this
> list...
>
>
> Just installed pgAdmin II and received no errors. I can
> connect to a database that I created from the command prompt
> on the database server but I cannot create a database
> properly from the pgadmin II client/workstation.
>
> The database is created but it has a red X on the icon. Allow
> connections is Yes but connection status is inaccessible. I
> can create users without a problem.
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>


Re: Hope it's ok to post a pgAdmin request for help in this list...

From
Andrew Biagioni
Date:
I'm not familiar with FreeBSD, but there is another way:  specify a parameter
for pc_ctl, "-D", which sets the PGDATA path overriding the $PGDATA variable:

pg_ctl -D /usr/local/pgctl/data reload

Substitute "/usr/local/pgctl/data" with the path to YOUR data directory, the
one you created at the end of the installation process.

Once you find how to set environment variables in FreeBSD (maybe try "man env"?
Just a guess), you can set $PGDATA to that same path, and you won't need to
specify it again.

        Andrew


3/29/03 3:53:28 AM, "Tamir Halperin" <tamir@brobus.net> wrote:

>I think I diagnosed the problem to be access restrictions in the pg_hba.conf
file.
>
>I made the changes but I can't run pg_ctl reload without first setting a
$PGDATA environment variable. Can someone please tell me how to do this
properly for PostgreSQL on my FreeBSD 4.6 system?
>
>> -----Original Message-----
>> From: Tamir Halperin
>> Sent: Saturday, March 29, 2003 3:19 AM
>> To: pgsql-admin@postgresql.org
>> Subject: [ADMIN] Hope it's ok to post a pgAdmin request for
>> help in this
>> list...
>>
>>
>> Just installed pgAdmin II and received no errors. I can
>> connect to a database that I created from the command prompt
>> on the database server but I cannot create a database
>> properly from the pgadmin II client/workstation.
>>
>> The database is created but it has a red X on the icon. Allow
>> connections is Yes but connection status is inaccessible. I
>> can create users without a problem.
>>
>>
>> ---------------------------(end of
>> broadcast)---------------------------
>> TIP 6: Have you searched our list archives?
>>
>> http://archives.postgresql.org
>>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster
>
>