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
been looking at either
> Does anyone out there have experience with this or recommended best
> practices? We have been looking at either (a) tunnelling everything
> over ssh, or (b) just making sure that users have "strong" passwords and
> requiring "md5" authentication in pg_hba.conf.
Have you considered using VPN
Hello,
I don't know if the C# postgresql provider can do this, but you can use
PostgreSQL with SSL + MD5 which would be fairly secure.
Another option would be to have them authenticate via a web application
that would open a tunnel specifically for that user per IP.
Sincerely,
Joshua D. Drake
Pa
Hi all!
I'm writing a script that presents the user with a numbered lines
menu, each line corresponding to a which executes a psql
command. As the psql-commands are very similar to each other (all of
them have the structure:
1.- psql mydb -x -c "SELECT * FROM tb_nm WHERE col_nm LIKE '%$k_r%'" )
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 been looking at either (a) tunnelling ev
=?iso-8859-1?q?Clodoaldo=20Pinto=20Neto?= <[EMAIL PROTECTED]> writes:
>> --- Tom Lane <[EMAIL PROTECTED]> escreveu:
>>> Googling for "OOM kill" will give you additional gory details :-(.
>>
> I did:
> # /sbin/sysctl -w vm.overcommit_memory=2
> vm.overcommit_memory = 2
> But it didn't help much:
> --- Tom Lane <[EMAIL PROTECTED]> escreveu:
> > the only mechanism I've heard of that causes this is the Linux
> > kernel's
> > out-of-memory killer --- see
> >
>
http://www.postgresql.org/docs/7.4/static/kernel-resources.html#AEN17068
> > Googling for "OOM kill" will give you additional gory de
* Richard Huxton <[EMAIL PROTECTED]> [020904, 16:54]:
> Ennio-Sr wrote:
>
> >My questions are then:
> [ ... ]
> >2. In case I put the memos in the main table, would it be possible to
> > control someway the display of memo-text fields? [Only some of the
> > records have a memo, and a referrin
Arundhati wrote:
Hi
I want the result of select query to be returned from a function. Or
is there any way to return a table from a function?
What you are looking for is a table function:
http://www.postgresql.org/docs/7.3/interactive/xfunc-tablefunctions.html
http://www.postgresql.org/docs/7.4/inte
"Ian Harding" <[EMAIL PROTECTED]> writes:
> Is there any way to debug a procedural language shared library when you can't
> createlang?
Hmm. I would bet on this being an abort() inside the dynamic linker.
It's annoying that it doesn't say anything beforehand :-( ... you are
capturing postmaster
> "SS" == Stephan Szabo <[EMAIL PROTECTED]> writes:
SS> You really should just need to drop the constraints and recreate them, not
SS> the entire schema.
So do I want to do deferred checks on all transactions, or just
some/one of them? I'm assuming that if the advice is to make them
initall
Hmm. I do a nightly dump of our production database, archive a copy
offsite, and verify the quality of the dump by running a little
verification script that is little more than a restore.
But if it would take you more than a day to do that, I'm not sure.
-tfo
On Sep 2, 2004, at 3:30 PM, Wes wrot
Is there any way to debug a procedural language shared library when you can't
createlang?
I get this...
L-897V601: {1} createlang pltcl template1
DEBUG: InitPostgres
DEBUG: StartTransactionCommand
DEBUG: PortalRun
DEBUG: CommitTransactionCommand
DEBUG: StartTransactionCommand
DEBUG: PortalR
On a nightly basis, we shut the database down and do a file system backup.
A short chronology of our database problem:
8/21 - count(*) of user tables succeeded (done once a week to get
statistics)
8/23 - A specific search on a specific value (one out of over 2 million)
caused postmaster to SEGV.
On Thu, 2 Sep 2004, Richard Huxton wrote:
> Ilia Chipitsine wrote:
> > Dear Sirs
> >
> > I'm about to write plpgsql function which will "vacuum full" all existing
> > databases. Below is an example how to get list of databases.
> >
> > What should I write instead of "raise notice" ?
>
> > raise
Hi,
yes, I have been hit by the, now also known to me, foreign key locking
"feature". And yes I did read that I should use "defer" to solve the
problem. Question is:
Do I have to recreate my schema with all foreign keys set to "initially
defered deferable"?
Ulrich
---(e
Hi Elie,
Now I got the right information from the DB in Hebrew and french.
Still can't save value in Hebrew from client (browser) to server and in
french if I save 'été' in a column varchar(3) I got a range over exception.
you are working through the web. That makes the whole thing a lot more
com
You've probably done this, but I should ask anyway.
Did you run the vcvars.bat to set the environment variables for MS VC?
I know I've run into this is previous versions, but IIRC it was operator error.
-Tony
---(end of broadcast)---
TIP 7: don't
> Ilia Chipitsine wrote:
> > Dear Sirs
> >
> > I'm about to write plpgsql function which will "vacuum full" all existing
> > databases. Below is an example how to get list of databases.
> >
> > What should I write instead of "raise notice" ?
>
> > raise notice ''datname = %'',list.datname;
>
> So
Ilia Chipitsine wrote:
Dear Sirs
I'm about to write plpgsql function which will "vacuum full" all existing
databases. Below is an example how to get list of databases.
What should I write instead of "raise notice" ?
raise notice ''datname = %'',list.datname;
Something like:
EXECUTE ''VACUUM FU
Am Donnerstag, 2. September 2004 09:32 schrieb Ilia Chipitsine:
> I'm about to write plpgsql function which will "vacuum full" all existing
> databases. Below is an example how to get list of databases.
>
> What should I write instead of "raise notice" ?
You normally cannot access different databa
Dear Sirs
I'm about to write plpgsql function which will "vacuum full" all existing
databases. Below is an example how to get list of databases.
What should I write instead of "raise notice" ?
CREATE OR REPLACE FUNCTION vacuum_all() RETURNS integer
AS '
DECLARE
query text;
list RECORD;
Hey guys I have written a plpgsql function which takes anyelement as
argument. If I pass a string as input It gives an error "invalid input
for integer" . Cant I pass any datatype for anyelement
---(end of broadcast)---
TIP 8: explain analyze is your
23 matches
Mail list logo
