Title: Connecting to PostgreSQL via PgAdmin III
I'm having trouble connecting to a Fedora Box that's running PostgreSQL. Below are my configuration files... any idea what I've setup incorrectly?
This is the error that I get when connecting with pgAdmin III
"Error connecting to the
Here's my config file...
pg_hba.conf
local all all
trust
PostgreSQL Users...
test=#
\du
List of database users User name | User ID
|
Attributes---+-+ aaron
| 100 | superuser, create
database postgres |
I've got a question about references, is it possible
to specify criteria for the Reference. For example, Table 1 has Field1
That References Field1 in Table2, However I only want Field 1 in Table
1 to reference the Records in Table2 that have the Valid Field set to
TRUE. In other words,
_str .= " dbname=".$this->name;
$this->link = pg_connect($conn_str)
or $this->logger("Database connection failed!","DBI");
break;
default:
$this->logger("Unknown database type in init()","DBI");
g_connect(): Unable to connect to PostgreSQL server: FATAL: IDENT
authentication failed for user "dbname=issue-tracker" . in
/var/www/html/issue-tracker/includes/classes/dbi.class.php on line 98 "
Thoughts?
-Original Message-
From: scott.marlowe [mailto:[EMAIL PROTECTED
I've got an authentication
questions. I've just setup pg_hba.conf to use "local
all all trust" for testing purposes, but
when the application I'm using tries to connect to the PostgreSQL Db (Using PHP)
I get the following error.
" Warning: pg_connect(): Unable to connect to P
