[ADMIN] pg_hba.conf

I’m trying to access our test postgreSQL server via VPN and even though I already setup the host for the vpn’s ip address, I’m still getting an error similar to “host for vpn address does not exist”   What am I doing incorrectly?   Thanks! - Lily Anne    

Re: [ADMIN] tcpip_socket=false and psql is working?

[EMAIL PROTECTED] wrote: > Hi all, > > I have compiled 7.4.1 on Debian Woody and found psql is working even if > tcpip_socket is set to false in postgresql.conf Sure, it uses unix domain sockets. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED]

Re: [ADMIN] Missing or errooneous pg_hba.conf file

I am in the process of having the Solaris 8 machine upgrading w/ latest patches. I will let you know if it fixes the problem. Thanks. Bill --- Tom Lane <[EMAIL PROTECTED]> wrote: > Bill Chandler <[EMAIL PROTECTED]> writes: > > LOG: invalid entry in pg_hba.conf file at line 60, > > token "255.25

[ADMIN] tcpip_socket=false and psql is working?

Hi all, I have compiled 7.4.1 on Debian Woody and found psql is working even if tcpip_socket is set to false in postgresql.conf Does anybody know about this or am I on LSD Thanks, Roman (somewhat confused) ---(end of broadcast)--- TIP 5: Have yo

[ADMIN] Exponential behaviour with UPDATE collisions?

Hi, I've been running some tests, and it seems that PostgreSQL has very bad behavior when multiple clients try to update the same row at the same time. I realize of course that concurrent updates are not a Good Thing, but PostgreSQL's reaction to it makes them very dangerous. I would expect that

Re: [ADMIN] Table maintenance: order of operations important?

Tom Lane wrote: Jeff Boes <[EMAIL PROTECTED]> writes: DELETE FROM foo WHERE date_expires < now(); VACUUM ANALYZE foo; CLUSTER foo; REINDEX TABLE foo; How would you choose to order these (under 7.4.x) for fastest turn-around? Does it matter? If you are going to CLUSTER then the VACUUM and

[ADMIN] Clustering Postgres

Has anyone heard of clusgres or, better yet, had any experience with it? I came across it while searching for active clustering projects. http://www.linuxlabs.com/clusgres.html Thanks in advance for the info! Kris ---(end of broadcast)--- TIP 6: Hav

Re: [ADMIN] Table maintenance: order of operations important?

Jeff Boes <[EMAIL PROTECTED]> writes: >DELETE FROM foo WHERE date_expires < now(); >VACUUM ANALYZE foo; >CLUSTER foo; >REINDEX TABLE foo; > How would you choose to order these (under 7.4.x) for fastest > turn-around? Does it matter? If you are going to CLUSTER then the VACUUM and

Re: [ADMIN] cannot connect to postgres db, strange error!

Nizar Ghazali <[EMAIL PROTECTED]> writes: > I’m running postgres 7.4.3 on HP-UX 11.11. When I want > to connect to my db, I have the following error: > psql: FATAL: _mdfd_getrelnfd: cannot open relation > pg_class: Permission denied Sounds to me like you started the postmaster as the wrong user

[ADMIN] Table maintenance: order of operations important?

We have a number of tables from which we expire (delete) rows nightly. Is there any value to ordering the operations, in terms of either table physical organization or elapsed time? E.g., DELETE FROM foo WHERE date_expires < now(); VACUUM ANALYZE foo; CLUSTER foo; REINDEX TABLE foo; How

[ADMIN] cannot connect to postgres db, strange error!

Hi,   I’m running postgres 7.4.3 on HP-UX 11.11. When I want to connect to my db, I have the following error:   psql: FATAL:  _mdfd_getrelnfd: cannot open relation pg_class: Permission denied     Do you have any idea where i have to look. I already looked at pg_hba.conf file and it l

[ADMIN] Problem accessing a postgreSQL trough VPN

Hi, I've a "little" problem while trying to access any pg database trough our VPN. It simply refuse the connection. Otherwise, The connection works fine on our server put in the DMZ with a classical connection. Our setup is: client: Eclipse with a JDBC driver trough VPN server: Pg SQL 7.4.2 wi

[ADMIN] cannot connect to postgres db, strange error!

Hi, I’m running postgres 7.4.3 on HP-UX 11.11. When I want to connect to my db, I have the following error: psql: FATAL: _mdfd_getrelnfd: cannot open relation pg_class: Permission denied Do you have any idea where i have to look. I already looked at pg_hba.conf file and it looks ok. Rega

[ADMIN] Choosing a system

We are currently running postgresql on a Solaris system.  We will be migrating the database to its own system within a few months.  I have the choice of using X86 or Redhat Linix, Solaris is not an option for the new system.  I'm curious of any preferences, bad experiences, incidents, etc that wou

Re: [ADMIN] To instal phpPgAdmin

On Thu, 2004-05-20 at 00:44, darshan patel wrote: > > I had instal postgresql on suse Linux,now i want to Instal phpPgAdmin so > what is the procedure Go to http://phppgadmin.sourceforge.net/?page=download unpack the source code and read the INSTALL file. Robert Treat -- Build A Brighter L

Re: [ADMIN] Servercrash

yesterday our database-server crashed (raid-error). After reparing the filesystem (ext2) we have a problem with our lagest table in the database. vaccuum aborts with the following meassage (sorry it is in German): DEBUG: vacuume »messungen.massendaten« HINWEIS: Relation »massendaten« TID 2115