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

[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.') How 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 kernels,

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 is a

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 many

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

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

[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] 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

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.

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 Db (Using

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

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

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