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
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
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
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,
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.
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
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
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
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
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
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
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
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
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
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
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
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
17 matches
Mail list logo