Re: [ADMIN] version:8.2.6 pg_hda.conf problem

Hi, I suppose the CIDR-ADDRESS mask length needs more attention. You have specified it as 254 and you IP says it as a single host. Why cant you try with 32 as the mask length. Try replacing listen_address=* with listen_addresses= in postgresql.conf FYI: http://www.postgresql.org/docs/8.

Re: [ADMIN] version:8.2.6 pg_hda.conf problem

> I had these in my pd_hda.conf : > > host all all 192.168.2.1/254 trust > > and listen_address=* in postgresql.conf, but it still not work . > > ps: I can not find tcpip_ ...in postgresql.conf. > > how can i do now ? Have you started the Postmaster in 'interactive' mode? You need to pass

Re: [ADMIN] version:8.2.6 pg_hda.conf problem

To allow this ip address(192.168.2.1) to work without a password, you may want to try this instead: host all all 192.168.2.1/32 trust *Robins Tharakan* On Fri, Feb 29, 2008 at 8:27 AM, 李国庆 <[EMAIL PROTECTED]> wrote: > Hi Everybody, >I started running 8.2.6 recen

[ADMIN] version:8.2.6 pg_hda.conf problem

Hi Everybody, I started running 8.2.6 recently on redhat 5.0 es, installed pgadmin3 and phppgadmin ,both them can correct connect by localhost,but can not from other , I had these in my pd_hda.conf : host all all 192.168.2.1/254 trust and listen_address=* in postgresql.conf, but it

Re: [ADMIN] Pgsql 8.2.5 Installation

On Wed, Feb 27, 2008 at 2:10 AM, Suresh Gupta VG <[EMAIL PROTECTED]> wrote: > Hi team, > > Actually, the installation of the PGSQL is done by root user only. Can > it be done with a normal user login? Does the user require any extra > permission from server side or DB side? It depends. If you

[ADMIN] drop database, vacuum full and disk space

Hi list. I've searched the archives and I've seen a lot of posts related to database size, vacuuming, etc., but I can't totally understand this. I've a small database of about 300Mb (when initially loaded), whose data is almost completely replaced in the night (via various "drop table" and the loa

Re: [ADMIN] Failover of the Primary database and starting the standby database in Postgresql in PITR configuraiton?

libra dba wrote: Hey Salman, Thanks a lot for all your guidance and help. It has really been a great help. I appreciate your quick replies. Which replication in postgres is better ? SLONY or WARM STANDBY (usning wal). I use both. Between our two production machines, we replicate data with

Re: [ADMIN] Failover of the Primary database and starting the standby database in Postgresql in PITR configuraiton?

Hey Salman, Thanks a lot for all your guidance and help. It has really been a great help. I appreciate your quick replies. Which replication in postgres is better ? SLONY or WARM STANDBY (usning wal). Another thing which haunts me is that, if we have a warm standby, the recovery process on the

Re: [ADMIN] Meaning of logs of postgresql

On Thu, Feb 28, 2008 at 06:15:29PM +0530, Suresh Gupta VG wrote: > WARNING: there is no transaction in progress This means you issued COMMIT when there was no BEGIN that started the transaction. I bet you're in autocommit mode and don't know it. > LOG: unexpected EOF on client connection Thi

[ADMIN] ES7000 Windows 2003 server 64bit processor

Hello All, We are facing some problems while downloading the Postgresql 8.2.4 version of 64bit processor for both Windows and SUSE Linux ES-7000 partitions. The entire download URL's of PostgreSQL 8.2.4 version are displaying the error message "The webpage can't found". Can you please let m

[ADMIN] Meaning of logs of postgresql

Hi team, I am in the testing of my application with the new database 8.2.5 on solaris-9. I get the logs as below when ever any transactions come from my application. What does it really mean? WARNING: there is no transaction in progress LOG: unexpected EOF on client connection Regard