Re: [ADMIN] Authentication Question

2003-10-28 Thread scott.marlowe
And you've restarted the server and all, right? Just for troubleshooting edit the 127.0.0.1 line for trust and restart and see if the problem goes away. I wonder if php changed behaviour on unix sockets versus TCP/IP somewhere along the way. We only use explicit host namd / TCP/IP nowadays wh

Re: [ADMIN] Authentication Question

2003-10-28 Thread Epps, Aaron M.
Here's the PHP code that's being used to create the connection string. It looks like it isn't inserting anything if the host name isn't specified... // Build the connection string $conn_str = "user=".$this->user; $conn_str .= !empty($this->pass) ? " password='".$this->p

Re: [ADMIN] Authentication Question

2003-10-28 Thread scott.marlowe
I bet your connect class is distilling your $db array down into a connect string that looks like: pg_connect("host= dbname=db user=username"); And the presence of a host= in there is goofing things up. Can you edit the class to make sure it isn't inserting a host= part before connecting? On T

Re: [ADMIN] Authentication Question

2003-10-28 Thread Epps, Aaron M.
There is no hostname specified in the PHP code when it connects to PostgreSQL, so it's using a socket connections then correct? Also, I did SIGHUP the PostgreSQL server after the configuration changes. Here's what the PHP config file looks like that's used to connect to PostgreSQL $db

Re: [ADMIN] Authentication Question

2003-10-28 Thread scott.marlowe
On Tue, 28 Oct 2003, Tom Lane wrote: > "Epps, Aaron M." <[EMAIL PROTECTED]> writes: > > I've got an authentication questions. I've just setup pg_hba.conf to use > > "localallalltrust" for testing purposes, but when the application I'm > > using tries to connect to the PostgreSQL

Re: [ADMIN] Authentication Question

2003-10-28 Thread scott.marlowe
On Tue, 28 Oct 2003, Epps, Aaron M. wrote: > I've got an authentication questions. I've just setup pg_hba.conf > to use "localallalltrust" for testing purposes, but when the > application I'm using tries to connect to the PostgreSQL Db (Using PHP) > I get the following error. >

Re: [ADMIN] Authentication Question

2003-10-28 Thread Bruno Wolff III
On Tue, Oct 28, 2003 at 14:12:31 -0600, "Epps, Aaron M." <[EMAIL PROTECTED]> wrote: > I've got an authentication questions. I've just setup pg_hba.conf to use "local >allalltrust" for testing purposes, but when the application I'm using > tries to connect to the PostgreSQL Db (

Re: [ADMIN] Authentication Question

2003-10-28 Thread Tom Lane
"Epps, Aaron M." <[EMAIL PROTECTED]> writes: > I've got an authentication questions. I've just setup pg_hba.conf to use "local >allalltrust" for testing purposes, but when the application I'm using > tries to connect to the PostgreSQL Db (Using PHP) I get the following error. >

[ADMIN] transaction read only "per" user

2003-10-28 Thread Gaetano Mendola
Hi all, now that in postgres 7.4 is possible have "read only transaction" I'm wandering if is it possible to specify somewhere ( pg_hba.conf ? ) that the user X can access the database Y in read only mode. Regards Gaetano Mendola ---(end of broadcast)--

[ADMIN] Authentication Question

2003-10-28 Thread Epps, Aaron M.
    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

[ADMIN] BLOBs and alternatives

2003-10-28 Thread Kent L. Nasveschuk
Hello, I am building a database for company employee info/records system. I just wanted to solicit some opinions on storage of images and documents. I'm using PG 7.3.4 on a Slackware 9 Linux system.I anticipate that the database will be at the bottom of a 3 tier design accessed through a web brows

[ADMIN] Help in Postgres Admin

2003-10-28 Thread Dilip Angal
Hi   We are an early stage startup compnay in San Francisco Bay area and we actively use Postgres for our Application. We need professional level support to maintain our postgress database. Any one intrested in SF bay area, please contact me.   [EMAIL PROTECTED]    

[ADMIN] Duplicating log lines from postmaster

2003-10-28 Thread Justin Cragin
I am seeing strange behavior with my postmaster logs, it seems to be writing out each line of a log entry 10 times. This seems to have started recently without any know config changes. I am running 7.3.2 on RedHat 7.3 i386. Below is a snippet from the logs. Thanks in advance for any help. Tha

Re: [ADMIN] another pg database corruption?

2003-10-28 Thread Andreas Schmitz
> Realy no.But I have many instalations with this version and the same > config. And all this is working well for long periode. > The problem is that the corrupted was the biggest one. The good thing about PC hardware is that it is "same same but different". The same hardware (board,cpu etc.) mi

Re: [ADMIN] another pg database corruption?

2003-10-28 Thread pginfo
Andrew Sullivan wrote: > On Tue, Oct 28, 2003 at 03:12:37PM +0100, pginfo wrote: > > > > > > > I do not have made any patchin on my kernel.I used the standart reiserfs > > with my linux distro. > > Yes, but have you kept up to date with new kernel releases from Red > Hat? Realy no.But I have ma

Re: [ADMIN] another pg database corruption?

2003-10-28 Thread Andrew Sullivan
On Tue, Oct 28, 2003 at 03:12:37PM +0100, pginfo wrote: > > > > I do not have made any patchin on my kernel.I used the standart reiserfs > with my linux distro. Yes, but have you kept up to date with new kernel releases from Red Hat? They're pretty good about releasing patched kernels if there i

Re: [ADMIN] another pg database corruption?

2003-10-28 Thread pginfo
Hi Andrew, Andrew Sullivan wrote: > On Mon, Oct 27, 2003 at 06:21:40PM +0100, pginfo wrote: > > Hi all, > > I am using pg 7.3.4 on linuz red hat 7.3 and reiserFS. > > How sure are you that your patch level for your kernel is good? ISTR > some issues with reiserfs on some versions of the recent k

[ADMIN]Retrieve Data Type

2003-10-28 Thread Monica Robustelli
Dear All, I have updated the release of my Postgres Database, from 7.0 to 7.3. From the old version, I effected the following query to retrieve type and length of a specific table field: select *from pgadmin_tables where (table_name='".$strTableName."') AND (column_name='".$strColumName."') Ho

Re: [ADMIN] another pg database corruption?

2003-10-28 Thread Andrew Sullivan
On Mon, Oct 27, 2003 at 06:21:40PM +0100, pginfo wrote: > Hi all, > I am using pg 7.3.4 on linuz red hat 7.3 and reiserFS. How sure are you that your patch level for your kernel is good? ISTR some issues with reiserfs on some versions of the recent kernels, but there've been so many filesystem pr