subscribe
end
___ALL-NEW Yahoo! Messenger -
all new features - even more fun! http://uk.messenger.yahoo.com
---(end of broadcast)---
TIP 9: the planner wil
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 us
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 computer
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
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 cha
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
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: <
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
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
behav
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
o
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]>; "P
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
bee
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
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.
Any
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,
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 compan
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
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 h
18 matches
Mail list logo
