Re: [ADMIN] pg_hba.conf

2004-05-27 Thread Tom Lane
C. Bensend [EMAIL PROTECTED] writes: I had setup my pg_hba.conf originally like this: host all all 10.15.0.0 255.255.255.0 trust I was under the impression that the .0 was supposed to be equivalent to a wildcard entry so that any connection from 10.15 would be able to

Re: [ADMIN] pg_hba.conf

2004-05-27 Thread LSanchez
Hi Mike, That's exactly how I had mine setup all along: host all all 10.29.15.0255.255.255.0trust and it just doesn't work via VPN. Thanks, - Lily Anne -Original Message- From: mike g [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 26, 2004 11:16 PM To: [EMAIL

Re: [ADMIN] pg_hba.conf

2004-05-27 Thread Jim Seymour
(Note: Please do not copy me individually on posts to the mailing list. I do read the list and don't need two copies. Thanks.) (Note2: I did Cc: this to LSanchez as she's yet to respond to any of my prior comments, so I begin to suspect she's not getting/reading the mailing list traffic?)

Re: [ADMIN] pg_hba.conf

2004-05-27 Thread LSanchez
Hi Jim, I apologize, but it seems that this is the first time that I received an email from you, but I did receive some emails from others about this issue, which I had been responding to. Or maybe, I'm not subscribed to the mailing list? I'll check this out and fix it asap. I will try what you

Re: [ADMIN] pg_hba.conf

2004-05-27 Thread Armstrong, Marc
Mike, I think if you set it up like this it would have worked as well: host all all 10.15.0.0 255.255.0.0 trust Your netmask was telling it that the first three octets of the IP address were significant. Marc Armstrong - Webmaster - Danly IEM - 440-239-7607 [EMAIL PROTECTED]

[ADMIN] What is safe to exclude when doing a UFS backup?

2004-05-27 Thread Marty Scholes
We are running a tiny ( 1GB) Pg installation, but are starting to migrate over our production Oracle apps. We run a daily Oracle dump and a daily Pg dump to /var/tmp, keeping the most recent four versions of each. Nightly, we have Veritas Netbackup backup the whole filesystem to a tape

Re: [ADMIN] What is safe to exclude when doing a UFS backup?

2004-05-27 Thread Bruce Momjian
Marty Scholes wrote: We are running a tiny ( 1GB) Pg installation, but are starting to migrate over our production Oracle apps. We run a daily Oracle dump and a daily Pg dump to /var/tmp, keeping the most recent four versions of each. Nightly, we have Veritas Netbackup backup the whole

[ADMIN] PHP version with postgres 7.4

2004-05-27 Thread Steve Lane
Hello all: I have several customers that I need to upgrade to postgres 7.4. Unfortunately they are also using somewhat older versions of PHP as well (4.1 and 4.2). Does anyone know offhand if there are any compatibility issues between PHP 4.1/4.2 and postgres 7.4? I'm opening to upgrading PHP as

Re: [ADMIN] What is safe to exclude when doing a UFS backup?

2004-05-27 Thread Marty Scholes
Bruce, Many thanks! Marty Bruce Momjian wrote: Marty Scholes wrote: We are running a tiny ( 1GB) Pg installation, but are starting to migrate over our production Oracle apps. We run a daily Oracle dump and a daily Pg dump to /var/tmp, keeping the most recent four versions of each. Nightly, we

Re: [ADMIN] PHP version with postgres 7.4

2004-05-27 Thread Mitch Pirtle
Steve Lane wrote: Hello all: I have several customers that I need to upgrade to postgres 7.4. Unfortunately they are also using somewhat older versions of PHP as well (4.1 and 4.2). Does anyone know offhand if there are any compatibility issues between PHP 4.1/4.2 and postgres 7.4? I'm opening to

Re: [ADMIN] Clustering Postgres

2004-05-27 Thread Greg Spiegelberg
Here's the basics basically because I ran out of time and budget to actually purchase it but here's what I know. 1 day to install. Installed RedHat ES 3.0 from scratch, and the PolyServe process took perhaps 1.5 hours to install including a kernel build and system reboot. Roughly 2 hours into

[ADMIN] PostgreSQL is hanging up !?

2004-05-27 Thread Louie Kwan
I have created several domains at Postgresql and I am trying to create some views on a domain dcenter using create or replace view cw_nodir_v as select ... However, my PostgreSQL hangs up.. on this domain only but not in other domains... Don't want to reboot PQ, and methods I can find out the

[ADMIN] pg_restore quick question

2004-05-27 Thread Sally Sally
I want to dump a database containing about five tables, each containing about 25 million records. I wanted to run pg_restore per table all at the same time. Would this have any undesirable consequences. I tried it on a smaller database and it seems to work fine. Let me know your thoughts ASAP

Re: [ADMIN] pg_hba.conf

2004-05-27 Thread Mike G
Thank you to all who replied with the additional info. On Thu, May 27, 2004 at 09:35:06AM -0400, Tom Lane wrote: C. Bensend [EMAIL PROTECTED] writes: I had setup my pg_hba.conf originally like this: host all all 10.15.0.0 255.255.255.0 trust I was under the impression

[ADMIN] Compiling problems with 7.4.2

2004-05-27 Thread Renney Thomas
I ran into a problem compiling 7.4.2 on Sun Solaris. The details are as follows. Thanks SunOS 5.8 Generic_108528-29 sun4u sparc SUNW,Ultra-1 Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.8/3.3.2/specs Configured with: ../configure --with-as=/usr/ccs/bin/as

Re: [ADMIN] Compiling problems with 7.4.2

2004-05-27 Thread Bruce Momjian
This will be fixed in 7.4.3. You can grab the 7.4 STABLE CVS tag if you want it now. --- Renney Thomas wrote: I ran into a problem compiling 7.4.2 on Sun Solaris. The details are as follows. Thanks SunOS 5.8