Re: [GENERAL] Gentoo for production DB server?

2004-09-03 Thread Gaetano Mendola
Barry S wrote: In article [EMAIL PROTECTED], Christine Desmuke wrote: Hello: At the risk of starting a flame-war, I'd like some more details on the use of Gentoo Linux for a production PostgreSQL server. There have been a couple of comments lately that it is not such a great idea; does anyone have

[GENERAL] test message -- wondering if the list is down -- please delete

2004-09-03 Thread Gregory S. Williamson
Sorry to waste bandwidth but I've never seen a day with no messages. G ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [GENERAL] postgres on in the internet

2004-09-03 Thread Jeff Amiel
Well...if it's truly a client/server app, why not have the client app talk to the server who actually executes the SQL. That way no remote access to the database is required. IMHO, it's a 'bad thing' to have your database exposed to the internet Jeff Amiel Paul Tillotson wrote: At my

Re: [GENERAL] How to determine a database is intact?

2004-09-03 Thread Richard Huxton
Wes wrote: On a nightly basis, we shut the database down and do a file system backup. A short chronology of our database problem: [snip] Question: How can we tell that a database is intact? In the above example, pg_dumpall worked on the 8/21 database. Did it become corrupt between 8/21 and 8/23,

[GENERAL] Ingres versus PostgreSQL

2004-09-03 Thread John Wells
Guys, Now that Ingres has been open-sourced, I'm curious about where it stands with regards to PostgreSQL. Is it a worthy competitor? PostgreSQL has been my database of choice for many years, and I'm very interested in how Ingres and PostgreSQL stack up in terms of features and performance.

Re: [GENERAL] How to determine a database is intact?

2004-09-03 Thread Richard Huxton
Wes wrote: On 9/3/04 3:11 AM, Richard Huxton [EMAIL PROTECTED] wrote: You shouldn't have to verify anything. PG's job is to never corrupt your data, and providing your hardware is good it should do so. If you are getting problems almost daily that would suggest a RAM/disk problem to me (sig 11

Re: [GENERAL] postgres on in the internet

2004-09-03 Thread Gaetano Mendola
Mike Mascari wrote: Paul Tillotson wrote: At my company we are looking at deploying clients for our client/server app outside our firewall, which will then require our postgres box to be internet-accessible. Does anyone out there have experience with this or recommended best practices? We have

[GENERAL] postgres on in the internet

2004-09-03 Thread Po Eddie Lim
Hello... Is it possible in PostGre 7.3 to query the size of a text[] array attribute of a table? Does anyone know how this is queried in 7.3? thanks... help is greatly needed. eddie - Original Message - From: Po Eddie Lim [EMAIL PROTECTED] To: Mike Nolan [EMAIL PROTECTED]; Paul

Re: [GENERAL] postgres on in the internet

2004-09-03 Thread Frank Knobbe
On Thu, 2004-09-02 at 18:35, Paul Tillotson wrote: At my company we are looking at deploying clients for our client/server app outside our firewall, which will then require our postgres box to be internet-accessible. Besides the already mentioned SSL session, consider tunneling postgres

[GENERAL] Overloading || ( text,text ) operator

2004-09-03 Thread Suresh Tri
Hi, I was trying to overload concat operator ||(text,text) such a way that it behaves like Oracle. i.e. I want 'abc' || null to return 'abc' instead of null. I know that it is not the expected behaviour in postgres, but since I am migrating the database from oracle to postgres , I need this

[GENERAL] pl/pgsql exceptions

2004-09-03 Thread Shelby Cain
Is there any way to retrieve the error code and error message text when an exception has been caught via exception when others in pl/pgsql? I'm looking essentially for the equivalent of Oracle's pl/sql sqlerrm and sqlcode variables. Regards, Shelby Cain

Re: [GENERAL] postgres on in the internet

2004-09-03 Thread Po Eddie Lim
Hello... Is it possible in PostGre 7.3 to query the size of a text[] array attribute of a table? Does anyone know how this is queried in 7.3? thanks... help is greatly needed. eddie - Original Message - From: Mike Nolan [EMAIL PROTECTED] To: Paul Tillotson [EMAIL PROTECTED] Cc: [EMAIL

Re: [GENERAL] postgres on in the internet

2004-09-03 Thread Lincoln Yeoh
I doubt it's a good idea to make your postgres server internet accessible. You'll be using postgresql in what I'd consider to be a less tested scenario. Most people don't expose their database servers to the Internet. You could use the following configuration: client (with IPSEC VPN) | Internet

Re: [GENERAL] psql \o weirdness

2004-09-03 Thread Ron St-Pierre
Peter Eisentraut wrote: Ron St-Pierre wrote: the line in the sql script to SELECT * FROM myFunction() \o /dev/null; output from this is suppressed. HOWEVER, I get an error when it tries to process the next line; psql:/usr/local/pgsql/quiet.sql:2: ERROR: syntax error at or near SELECT at

Re: [GENERAL] postgres on in the internet

2004-09-03 Thread Daniel Martini
Hi, Citing Paul Tillotson [EMAIL PROTECTED]: At my company we are looking at deploying clients for our client/server app outside our firewall, which will then require our postgres box to be internet-accessible. Does anyone out there have experience with this or

Re: [GENERAL] postgres on in the internet

2004-09-03 Thread Paul Tillotson
How difficult is it to set up VPN? I know that in the past my company has used VPN tunnels, but this was difficult for our remote users to get set up. I am actually willing to trade *some* security for ease of installation and simplicity. This will have to be deployed on 30 to 40 client

Re: [GENERAL] How to determine a database is intact?

2004-09-03 Thread Wes
On 9/3/04 3:11 AM, Richard Huxton [EMAIL PROTECTED] wrote: You shouldn't have to verify anything. PG's job is to never corrupt your data, and providing your hardware is good it should do so. If you are getting problems almost daily that would suggest a RAM/disk problem to me (sig 11 usually