Hi Max,
To find out what is causing the big load you could also try to use 'ATOP'
which can be found at http://www.atcomputing.nl/atop. This tool shows more
(accurate) information than the regular TOP.
There are also some kernel patches available which, when applied to your
kernel, even show more
I am trying to implement the new out parameters in functions and
stumbled upon a problem.
There is an internal requirement for our databases that every
function call always returns 2 params status & status_text.
The problem now is that plpgsql selects the out params themselves
into out params
On Thu, 23 Aug 2007 08:29:03 +0400, Tom Lane <[EMAIL PROTECTED]> wrote:
"Max Zorloff" <[EMAIL PROTECTED]> writes:
... The problem is that after the number of concurrent users rises to
100, CPU becomes almost 100% loaded. How do I find out what's hogging
the
CPU?
'top' shows demon using 8%
On 23.08.2007, at 8:51, Kristo Kaiv wrote:
I am trying to implement the new out parameters in functions and
stumbled upon a problem.
There is an internal requirement for our databases that every
function call always returns 2 params status & status_text.
The problem now is that plpgsql selec
Hello,
I would like to be able to restrict the access to a database so that
only a specific program running on the same machine can access it, is
this possible ? So I would like to have some kind of secure
authentication(or something) between the database and the program, and
the user running the
On 23.08.2007, at 11:11, Kristo Kaiv wrote:
On 23.08.2007, at 8:51, Kristo Kaiv wrote:
I am trying to implement the new out parameters in functions and
stumbled upon a problem.
There is an internal requirement for our databases that every
function call always returns 2 params status & sta
Ed L. wrote:
> On Tuesday 21 August 2007 1:45 pm, Scott Marlowe wrote:
>> If you have a large db in 7.4.6, you should do two things.
>>
>> 1: Update to 7.4.19 or whatever the latest flavor of 7.4 is,
>> right now. There are a few known data eating bugs in 7.4.6.
>
> Sounds like good advice from a
On 23.08.2007 11:04, Max Zorloff wrote:
When one postgres process waits for lock to release does it use any cpu?
And also, when apache waits for query to finish, does it use cpu?
No, but are you sure what you see is not i/o wait? What values does top
display in the %wa columns in the CPU rows?
Tony Caduto wrote:
> Other than that I would say PG kicks butt.
You're just realising that? :-)
> If there is any interest I could also add MySQL 5.0 to the mix as the
> third column.
I'd be interested to see that.
Regards, Dave
---(end of broadcast)
On 23/08/07, Scott Marlowe <[EMAIL PROTECTED]> wrote:
>
> Yeah, I'm not the biggest fan of CR, but it's worked with PostgreSQL
> for quite some time now. We had it hitting a pg7.2 db back in the
> day, when hip kids road around in rag top roadsters and wore tshirts
> with cigarettes rolled in thei
yes, 128 MB is pretty pretty small.
Maybe the HP Smart Array P800 controller would be a better choice(if you
need an hp product).
BTW how many harddisks are you using ? Wich RAID ? I am using ext3 as a
filesystem (but you have to use the new linux kernels).
Try to use another filesystem then ext2
Tony Caduto wrote:
> Check it out here:
>
> http://www.amsoftwaredesign.com/pg_vs_fb
Couple of corrections Tony:
- You don't necessarily need to stop the postmaster to take a filesystem
backup -
http://www.postgresql.org/docs/8.2/interactive/continuous-archiving.html#BACKUP-BASE-BACKUP.
Obviousl
On Thu, 2007-08-23 at 16:42 +0800, Phoenix Kiula wrote:
> On 23/08/07, Scott Marlowe <[EMAIL PROTECTED]> wrote:
> >
> > Yeah, I'm not the biggest fan of CR, but it's worked with PostgreSQL
> > for quite some time now. We had it hitting a pg7.2 db back in the
> > day, when hip kids road around in r
On Thu, 23 Aug 2007 12:24:32 +0400, Hannes Dorbath
<[EMAIL PROTECTED]> wrote:
On 23.08.2007 11:04, Max Zorloff wrote:
When one postgres process waits for lock to release does it use any cpu?
And also, when apache waits for query to finish, does it use cpu?
No, but are you sure what you see
Phoenix Kiula wrote on 23.08.2007 10:42:
On 23/08/07, Scott Marlowe <[EMAIL PROTECTED]> wrote:
Yeah, I'm not the biggest fan of CR, but it's worked with PostgreSQL
for quite some time now. We had it hitting a pg7.2 db back in the
day, when hip kids road around in rag top roadsters and wore tshi
>
> > Now
> >
> > select lexize('ru_ispell_cp1251', 'Дмитриев') -> "Дмитрий"
> > select lexize('ru_ispell_cp1251', 'Иванов') -> "Иван"
> > - it is completely wrong!
> >
> > I have a database with all Russian name, is it possible to use it (how?)
> to
>
> if you have such database why just don't wri
Joshua D. Drake wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
John DeSoi wrote:
On Aug 22, 2007, at 7:21 PM, Geoffrey wrote:
We are looking for an open source reporting tool that will enable
users to generate their own reports. Something like Crystal Reports. ;)
I was looking at a co
Thanks for the various responses, I'll check them out and post my
research results and our decision.
--
Until later, Geoffrey
Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
- Benjamin Franklin
---(e
Hello all,
I am having problems with the next postgresql version:
pg version: 8.2.4
OS: Win32 (windows xp sp2)
FS: NTFS
It is a production server, but suddenly the DB stop answering to any sql
command. It seems dead. After restart server all starts to works again.
I am looking for system e
--- Tom Lane <[EMAIL PROTECTED]> wrote:
>
> I can't help thinking you are looking at generalized
> system
> instability. Maybe someone knocked a few cables
> loose while
> installing new network hardware?
Database server/storage instability or network
instability?
There is no doubt that there
On Thu, 23 Aug 2007, Dmitry Koterov wrote:
Now
select lexize('ru_ispell_cp1251', 'Дмитриев') -> "Дмитрий"
select lexize('ru_ispell_cp1251', 'Иванов') -> "Иван"
- it is completely wrong!
I have a database with all Russian name, is it possible to use it (how?)
to
if you have such database wh
On Thu, 2007-08-23 at 06:20 -0400, Geoffrey wrote:
> Joshua D. Drake wrote:
> > -BEGIN PGP SIGNED MESSAGE-
> > Hash: SHA1
> >
> > John DeSoi wrote:
> >> On Aug 22, 2007, at 7:21 PM, Geoffrey wrote:
> >>
> >>> We are looking for an open source reporting tool that will enable
> >>> users to
On 23.08.2007, at 11:23, Alban Hertroys wrote:
Ed L. wrote:
On Tuesday 21 August 2007 1:45 pm, Scott Marlowe wrote:
If you have a large db in 7.4.6, you should do two things.
1: Update to 7.4.19 or whatever the latest flavor of 7.4 is,
right now. There are a few known data eating bugs in 7.
Ged wrote:
Ty for those comments.
Hmm, I did try it out before posting of course, and I've just tried it
again to make sure I hadn't boobed with a typo. It seems my ISP is
running 8.0.8 and it's definitely not working on that. It *is* in the
8.0.13 documentation also though... So now I'm off to
>
> write your own dictionary, which implements any logic you need. In your
> case it's just a wrapper around ispell, which will returns original string
> not stem. See example
> http://www.sai.msu.su/~megera/postgres/fts/doc/fts-intdict-xmp.html
> and russian article
> http://www.sai.msu.su/~meger
On Aug 23, 2007, at 7:44 , Kristo Kaiv wrote:
On 23.08.2007, at 11:23, Alban Hertroys wrote:
Since you're setting up replication to another database, you might as
well try replicating to a newer release and swap them around once
it's
done. I've seen that method of upgrading mentioned on th
On Wed, 2007-08-22 at 18:57 -0400, Geoffrey wrote:
> We are looking for a reporting tool that will enable users to generate
> their own reports. Something like Crystal Reports.
>
> Anyone using something like this with Postgresql?
>
agata, datavision, jasper reports, birt, openRPT -- google s
I am slightly worried that corruption of data files may
remain undetected in PostgreSQL.
As an experiment, I created a simple table with a primary key
index and inserted a couple of rows. The corresponding data file
is 1 page = 8K long.
Now when I stop the server, zero out the data file with
dd i
On 8/23/2007 5:16 AM Thomas Kellerer wrote:
Phoenix Kiula wrote on 23.08.2007 10:42:
On 23/08/07, Scott Marlowe <[EMAIL PROTECTED]> wrote:
Yeah, I'm not the biggest fan of CR, but it's worked with PostgreSQL
for quite some time now. We had it hitting a pg7.2 db back in the
day, when hip kids r
Hi,
For my projet (J2EE application), I have been using Jasper and iReport.
That works quite well although so far we have not done stuff really complicated.
I am hoping that the "Power" end users will be able to write the reports
themselves. "Power" users because although iReports is wysiwyg too
Michael Glaesemann wrote:
>
> On Aug 22, 2007, at 1:02 , Frank Millman wrote:
>
> > I want to store data in a 'tree' form, with a fixed number
> of levels,
> > so that each level has a defined role.
>
Thanks very much for the in-depth response, Michael. Plenty for the little
grey cells to wor
Lange Marcus wrote:
Hi,
I guess the answer to the 2 questions would be, yes the user will
probably have physical access to the machine, but will not have
superuser access. The OS is, atleast for now, windows.
I have been looking and searching manuals and so on for different
methods but I still
On Aug 23, 2007, at 8:59 , Frank Millman wrote:
It certainly does. Thanks again for all the valuable advice.
Glad you found it helpful. Good luck!
Michael Glaesemann
grzm seespotcode net
---(end of broadcast)---
TIP 2: Don't 'kill -9' the po
Ned Lilly wrote on 23.08.2007 15:44:
This is specifically why we released OpenRPT as open source - it's very
lightweight, no Java required. http://sf.net/projects/openrpt
I am a Java developer and thus I have no problems in using Java based tools.
Especially because I ususally only have a JDB
Terry Yapt wrote:
> I am looking for system errors and nothing is there. But I have a lot of
> messages on system APP errors. The error is the same every ten seconds or
> so.
>
> This is the main error:
> * FATAL: could not reattach to shared memory (key=5432001, addr=01D8):
> Invalid ar
Jeff Amiel <[EMAIL PROTECTED]> writes:
> Would a good stack trace (assuming I want to crash my
> database again) help here?
Well, it'd be more information than we have now ...
regards, tom lane
---(end of broadcast)---
TIP 5
I looked at BIRT - it is part of Eclipse. It is pretty new and I found the
documentation to be pretty limited. Also, it has few output options. These
factors caused me to decide against it. Settled on JasperReports and like it a
lot. It integrated easily with my Java (Eclipse RCP) GUI. Cre
On Aug 23, 2007, at 12:00 AM, Tony Caduto wrote:
Check it out here:
http://www.amsoftwaredesign.com/pg_vs_fb
When comparing in the grid the only major advantage FB has is
probably BLOB support.
PG only suppports 1 gb while FB supports 32gb. Bytea is pretty
slow as well when compared to
Hey all,
When I try and install form the msi installer for version 8.2.4 I get
the following error.
Failed to run initdb: 128!
And when it tells me to see the logfile for details, there is no log
file in the tmp directory.
Anyone know why it's doing this?
It crashes furring the
Dave Page wrote:
Couple of corrections Tony:
- You don't necessarily need to stop the postmaster to take a filesystem
backup -
http://www.postgresql.org/docs/8.2/interactive/continuous-archiving.html#BACKUP-BASE-BACKUP.
Obviously that assumes logs will be replayed during recovery.
- The native
Dave Page wrote:
Tony Caduto wrote:
Other than that I would say PG kicks butt.
You're just realising that? :-)
Ah, I new that around 2004 :-) I just have to convince Delphi users of
that :-)
Later,
Tony
---(end of broadcast)-
I want to create a function that receive a list argument and filter
data with IN operator. Example:
CREATE OR REPLACE FUNCTION "public"."ffoo" (list ???) RETURNS VOID AS
$body$
BEGIN
select * from foo where foo_column in list;
END;
$body$
LANGUAGE 'plpgsql' ;
I played with arrays but I got no s
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Tony Caduto wrote:
> Dave Page wrote:
>> Tony Caduto wrote:
>>
>>> Other than that I would say PG kicks butt.
>>>
>>
>> You're just realising that? :-)
>>
>>
>
> Ah, I new that around 2004 :-) I just have to convince Delphi users of
> that
On 8/23/2007 10:07 AM Thomas Kellerer wrote:
Ned Lilly wrote on 23.08.2007 15:44:
This is specifically why we released OpenRPT as open source - it's
very lightweight, no Java required. http://sf.net/projects/openrpt
I am a Java developer and thus I have no problems in using Java based
tool
"Albe Laurenz" <[EMAIL PROTECTED]> writes:
> - Shouldn't there be an error, some kind of 'missing magic
> number' or similar, when a table file consists of only
> zeros?
The particular case of an all-zeroes page is specifically allowed,
and has to be because it's a valid transient state in var
Hello.
I have a subject setup and a few questions.
The first one is this. PHP establishes a connection to the Postgres
database through pg_pconnect(). Then it
runs some query, then the script returns, leaving the persistent
connection hanging. But the trouble
is that in this case any query t
On Aug 23, 2007, at 11:56 AM, Gustavo Tonini wrote:
I want to create a function that receive a list argument and filter
data with IN operator. Example:
CREATE OR REPLACE FUNCTION "public"."ffoo" (list ???) RETURNS VOID AS
$body$
BEGIN
select * from foo where foo_column in list;
END;
$body$
LA
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Max Zorloff wrote:
> Hello.
>
> I have a subject setup and a few questions.
>
> The first one is this. PHP establishes a connection to the Postgres
> database through pg_pconnect().
Don't use pconnect. Use pgbouncer or pgpool.
> Then it
> runs som
Hello Group,
I have asked this question already on the NpgSql forum, but didn't get a
response so far. Sorry for cross posting, but want to check if any one had
any suggestions for my problem.
I am trying to do my updates through NpgsqlDataAdapter (I also tried with
Odbc driver with no luck) by
Hello,
I am writing an application in Borland C++ builder 5 that connects to a
postgresql database (8.2.4).
I am trying to link a TDBListBox to a view by using a TTable and a
TDataSource component but when I send the TTable->Refresh() I get the
following error:
"Table does not support this opera
Hi Max,
To find out what is causing the big load you could also try to use 'ATOP'
which can be found at http://www.atcomputing.nl/atop. This tool shows more
(accurate) information than the regular TOP.
There are also some kernel patches available which, when applied to your
kernel, even show more
A while ago Kevin Murphy reported that PG built for 64 bit
archetecture cant start on a OSX:
http://archives.postgresql.org/pgsql-general/2007-04/msg00788.php
The problem was eventually traced to a compatability problem with OSX:
http://lists.apple.com/archives/darwin-kernel/2007/Apr/msg00021.h
If query development is an important part of what you need to do,
consider dbQwikEdit. It's not open or free. But you can get a minimal
config for free (I think) and it's pretty cheap copnsidering what it can
do.
It uses ODBC and can read any DB that ODBC points to (Oracle, MySQL,
Postgres, SQLS
In response to "Joshua D. Drake" <[EMAIL PROTECTED]>:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Max Zorloff wrote:
> > Hello.
> >
> > I have a subject setup and a few questions.
> >
> > The first one is this. PHP establishes a connection to the Postgres
> > database through pg_pconn
--- Tony Caduto <[EMAIL PROTECTED]> wrote:
> Check it out here:
>
> http://www.amsoftwaredesign.com/pg_vs_fb
One row that you could elaborate on is:
CHECK CONSTRAINTS support for correlated sub-queries.
PostgreSQL doesn't official support this kink of constraint unless it is rolled
up in a func
Richard,
I have added transaction to my code and it took about 2 and half hours to
process around 48,000 records. Again all this time is taken by update method
on the adapter.
I don't know Perl to setup the database link to SQL Server 2005 and also I
don't have permission to write the data to fil
At 11:28 PM 8/22/2007, Dmitry Koterov wrote:
Hello.
We are trying to use HP CISS contoller (Smart Array E200i) with
internal cache memory (100M for write caching, built-in power
battery) together with Postgres. Typically under a heavy load
Postgres runs checkpoint fsync very slow:
checkpoin
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Murali Maddali wrote:
> Richard,
>
> I have added transaction to my code and it took about 2 and half hours to
> process around 48,000 records. Again all this time is taken by update method
> on the adapter.
>
> I don't know Perl to setup the databas
On Aug 23, 2007, at 12:29 PM, Bill Moran wrote:
In response to "Joshua D. Drake" <[EMAIL PROTECTED]>:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Max Zorloff wrote:
Hello.
I have a subject setup and a few questions.
The first one is this. PHP establishes a connection to the Postgres
data
On Fri, 24 Aug 2007, Lincoln Yeoh wrote:
BTW, what happens if someone replaced a faulty battery backed controller card
on a "live" system with one from a "don't care test system" (identical
hardware tho) that was powered down abruptly because people didn't care?
Would the new card proceed to t
On Thu, 23 Aug 2007 13:29:46 -0400
Bill Moran <[EMAIL PROTECTED]> wrote:
> > Well you haven't given us any indication of data set or what you
> > are trying to do. However, I can tell you, don't use pconnect,
> > its broke ;)
>
> Broke? How do you figure?
I asked that question earlier this mont
At 01:30 AM 8/24/2007, Murali Maddali wrote:
options like a different driver I can use or through stored procedures. I
have to compare each column in each row before doing the update.
Do you have to compare with all rows, or just one? Can your
comparison make use of an index?
Link.
--
On Thu, 23 Aug 2007 21:16:48 +0400, Joshua D. Drake <[EMAIL PROTECTED]>
wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Max Zorloff wrote:
Hello.
I have a subject setup and a few questions.
The first one is this. PHP establishes a connection to the Postgres
database through pg_pconnec
On 8/23/07, Tony Caduto <[EMAIL PROTECTED]> wrote:
> Check it out here:
>
> http://www.amsoftwaredesign.com/pg_vs_fb
> If there is any interest I could also add MySQL 5.0 to the mix as the
> third column.
If you do, you should really do it as MySQL-isam and MySQL-innodb.
the limitations of each t
On Thu, 23 Aug 2007 21:29:46 +0400, Bill Moran <[EMAIL PROTECTED]>
wrote:
In response to "Joshua D. Drake" <[EMAIL PROTECTED]>:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Max Zorloff wrote:
> Hello.
>
> I have a subject setup and a few questions.
>
> The first one is this. PHP establishe
If anyone is interested, I could answer the questions for Oracle and
you could add those, too. Be interesting to see a chart like that
(that stays updated after releases) for a large assortment of
databases.
If we add a bunch of different databases, it might be easier to
manipulate if it was stor
Erik Jones <[EMAIL PROTECTED]> writes:
> On Aug 23, 2007, at 11:56 AM, Gustavo Tonini wrote:
>> I want to create a function that receive a list argument and filter
>> data with IN operator. Example:
> CREATE OR REPLACE FUNCTION public.ffoo(list sometype[]) RETURNS VOID
this is right ...
> ex
Tom Lane wrote:
Ok, I can do this, but why can more memory be harmful?
Because you've left no room for anything else? The kernel, the various
other daemons, the Postgres code itself, and the local memory for each
Postgres process all require more than zero space.
So doe
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Lewis Cunningham wrote:
> If anyone is interested, I could answer the questions for Oracle and
> you could add those, too. Be interesting to see a chart like that
> (that stays updated after releases) for a large assortment of
> databases.
>
> If we
On Thu, Aug 23, 2007 at 08:30:46PM +0200, Christian Schröder wrote:
>Thanks for your tips! I have changed the "shared_buffers" setting back
>to 2 GB. It was set to 2 GB before, but we also had "out of memory"
>errors with this setting, so I raised it to 3 GB.
You've got it completely w
In response to Josh Trutwin <[EMAIL PROTECTED]>:
> On Thu, 23 Aug 2007 13:29:46 -0400
> Bill Moran <[EMAIL PROTECTED]> wrote:
>
> > > Well you haven't given us any indication of data set or what you
> > > are trying to do. However, I can tell you, don't use pconnect,
> > > its broke ;)
> >
> > B
On Aug 23, 2007, at 1:27 PM, Tom Lane wrote:
Erik Jones <[EMAIL PROTECTED]> writes:
On Aug 23, 2007, at 11:56 AM, Gustavo Tonini wrote:
I want to create a function that receive a list argument and filter
data with IN operator. Example:
CREATE OR REPLACE FUNCTION public.ffoo(list sometype[])
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Tony Caduto wrote:
> Dave Page wrote:
>> Couple of corrections Tony:
>>
>> - You don't necessarily need to stop the postmaster to take a filesystem
>> backup -
>> http://www.postgresql.org/docs/8.2/interactive/continuous-archiving.html#BACKUP-BASE-BACK
On 8/21/07, JLoz <[EMAIL PROTECTED]> wrote:
> I have not been able to find a workaround for this?
Does the table have a unique index/primary key?
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
On Thu, 23 Aug 2007, Tony Caduto wrote:
If there is any interest I could also add MySQL 5.0 to the mix as the third
column.
As already mentioned, MyISAM and InnoDB should get their own columns.
This is a really good comparision, focusing on features that I think
people understand rather than
Sorry, I have not be able to execute "ipcs" on windows. it doesn't
exists. I have tried to find some utility that gives me the same
information or any ipcs porting to win32, but I haven't had any luck.
If I can do something more to get help, please tell me.
Greetings.
Alvaro Herrera escrib
Terry Yapt wrote:
> This is the main error:
> * FATAL: could not reattach to shared memory (key=5432001, addr=01D8):
> Invalid argument
>
> It is always followed by this another system-app error:
> * LOG: unrecognized win32 error code: 487
FWIW,
http://help.netop.com/support/errorcodes/win
On Thu, Aug 23, 2007 at 03:30:30PM -0400, Greg Smith wrote:
> On Thu, 23 Aug 2007, Tony Caduto wrote:
>
> >If there is any interest I could also add MySQL 5.0 to the mix as the
> >third column.
>
> As already mentioned, MyISAM and InnoDB should get their own columns.
Yes.
> This is a really go
Ok. It works well, but my argument type must be varchar (because java
conversions in my application). Then I want to convert varchar in
format "{int, int, ...}" to an integer array. Is there a function that
converts varchar -> integer [] ? I tried with casts and got no
success.
Tanks,
Gustavo.
On
Alvaro Herrera escribió:
Terry Yapt wrote:
This is the main error:
* FATAL: could not reattach to shared memory (key=5432001, addr=01D8):
Invalid argument
It is always followed by this another system-app error:
* LOG: unrecognized win32 error code: 487
This problem has been r
Alvaro Herrera wrote:
> Terry Yapt wrote:
>
>> This is the main error:
>> * FATAL: could not reattach to shared memory (key=5432001, addr=01D8):
>> Invalid argument
>>
>> It is always followed by this another system-app error:
>> * LOG: unrecognized win32 error code: 487
>
> FWIW,
> http:/
Magnus Hagander wrote:
> Alvaro Herrera wrote:
> > No resolution seems to have been found.
>
> 8.3 will have a new way to deal with shared mem on win32. It's the same
> underlying tech, but we're no longer trying to squeeze it into an
> emulation of sysv. With a bit of luck, that'll help :-)
So
Joshua D. Drake wrote:
I have added transaction to my code and it took about 2 and half hours to
process around 48,000 records. Again all this time is taken by update method
on the adapter.
I don't know Perl to setup the database link to SQL Server 2005 and also I
don't have permission to write
>- Original Message
>From: Magnus Hagander <[EMAIL PROTECTED]>
>To: Alvaro Herrera <[EMAIL PROTECTED]>
>Cc: Terry Yapt <[EMAIL PROTECTED]>; pgsql-general@postgresql.org
>Sent: Thursday, August 23, 2007 3:43:32 PM
>Subject: Re: [GENERAL] FATAL: could not reattach to shared memory (Win32)
>
Lange Marcus wrote:
> I would like to be able to restrict the access to a database so that
> only a specific program running on the same machine can access it,
In postgresql.conf, set
unix_socket_permissions = 770
unix_socket_group = postgres
and make your program setgid postgres. Or some varia
On Aug 18, 2007, at 5:20 AM, Phoenix Kiula wrote:
I am writing some simple batch scripts to login to the DB and do a
pg_dump. Also, when I login to do my own SQL tinkering, I'd like not
to be asked for a password every time (which, for silly corporate
reasons, is quite a convoluted one).
So I re
On Aug 21, 2007, at 12:04 AM, Tom Lane wrote:
If you need to deal with very large result sets, the standard advice
is to use a cursor so you can pull a few hundred or thousand rows
at a time via FETCH.
In case it's not obvious... in this case you might want to dump the
output of that query in
On Aug 22, 2007, at 3:37 PM, Joshua D. Drake wrote:
You can not do multi master cross continent reliably.
I'm pretty sure that credit card processors and some other companies
do it... it just costs a LOT to actually do it well.
--
Decibel!, aka Jim Nasby[EMAIL PROTECT
On Aug 19, 2007, at 7:23 AM, Bill Moran wrote:
Assumptions:
a. After pg_stop_backup(), Pg immediately recycles log files and
hence wal
logs can be copied to backup. This is a clean start.
I don't believe so. ARAIK, all pg_stop_backup() does is remove the
marker that pg_start_backup() put in
On Aug 17, 2007, at 5:48 PM, Joey K. wrote:
We have several web applications with Pg 8.2.x running on isolated
servers (~25). The database size on each machines (du -h pgdata) is
~2 GB. We have been using nightly filesystem backup (stop pg, tar
backup to ftp, start pg) and it worked well.
On Aug 17, 2007, at 5:37 PM, Andrej Ricnik-Bay wrote:
On 8/14/07, john_sm <[EMAIL PROTECTED]> wrote:
Hey guys, for an enterprise wide deployment, what will you
suggest and why among - Red Hat Linux, Suse Linux and
Ubuntu Linux, also, do you think, we can negotiate the
support pricing down?
For
Decibel! <[EMAIL PROTECTED]> wrote:
>
> On Aug 22, 2007, at 3:37 PM, Joshua D. Drake wrote:
> > You can not do multi master cross continent reliably.
>
> I'm pretty sure that credit card processors and some other companies
> do it... it just costs a LOT to actually do it well.
Isn't this sort o
Bill Moran wrote:
> I guess I just feel that "broken" is a bit of a harsh term. If
> your expectations are for full-blown connection management from
> pconnect(), then you will be disappointed. If you take it for
> what it is: persistent connections, then those limitations would
> be expected.
I
Decibel! <[EMAIL PROTECTED]> wrote:
>
> On Aug 19, 2007, at 7:23 AM, Bill Moran wrote:
> >> Assumptions:
> >> a. After pg_stop_backup(), Pg immediately recycles log files and
> >> hence wal
> >> logs can be copied to backup. This is a clean start.
> >
> > I don't believe so. ARAIK, all pg_stop_b
On Aug 23, 2007, at 7:57 , Richard Huxton wrote:
Ged wrote:
Ty for those comments.
Hmm, I did try it out before posting of course, and I've just
tried it
again to make sure I hadn't boobed with a typo. It seems my ISP is
running 8.0.8 and it's definitely not working on that. It *is* in the
Hi,
I'm new to Regex in Postgres. Can someone give me a quick pointer on
how I'd SELECT the substring between ''and '' in
a field?
Sample field data:
address city here Rogers, Jim zip code place
and I'd like the SELECT to return only:
Rogers, Jim
Thanks!
---(en
On Aug 23, 2007, at 19:33 , Postgres User wrote:
I'm new to Regex in Postgres. Can someone give me a quick pointer on
how I'd SELECT the substring between ''and '' in
a field?
Check out regexp_replace:
http://www.postgresql.org/docs/8.2/interactive/functions-
matching.html#FUNCTION
Yes, I read the manual. I think I had a problem because of the
special chars (< / >) that I'm trying to search for... Still looking
for the right syntax.
On 8/23/07, Michael Glaesemann <[EMAIL PROTECTED]> wrote:
>
> On Aug 23, 2007, at 19:33 , Postgres User wrote:
>
> > I'm new to Regex in Postg
[Please don't top post as it makes the discussion more difficult to
follow, and please reply to the list so that others may benefit from
and participate in the discussion.]
On Aug 23, 2007, at 19:49 , Postgres User wrote:
Yes, I read the manual. I think I had a problem because of the
speci
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 08/23/07 17:22, Bill Moran wrote:
> Decibel! <[EMAIL PROTECTED]> wrote:
>> On Aug 22, 2007, at 3:37 PM, Joshua D. Drake wrote:
>>> You can not do multi master cross continent reliably.
>> I'm pretty sure that credit card processors and some other co
1 - 100 of 111 matches
Mail list logo
