On Aug 24, 2007, at 1:32 , Richard Huxton wrote:
It's a "forgot to cc:" issue - forgot to remind, I'm afraid.
Thanks for checking, Richard. Was wondering if my email service was
acting up again.
Michael Glaesemann
grzm seespotcode net
---(end of broadcast)--
Ok. But apart from the risk with having the physical access to the computer,
would it be a reasonable safe solution to limit the access with a password then
? So that, assuming a user does not have the possibility to get any kind of
root access, there is no way to read or copy the database unles
Michael Glaesemann wrote:
I don't seem to have received the message Richard's responding to. The
archives seem to be missing a couple as well.
http://archives.postgresql.org/pgsql-general/2007-08/threads.php#01346
Anyone else besides Richard catch these messages? Any idea where they
may hav
Shelby Cain wrote:
>> - 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
On Thu, 2007-08-23 at 19:08 -0700, Postgres User wrote:
> On 8/23/07, Michael Glaesemann <[EMAIL PROTECTED]> wrote:
> >
> > On Aug 23, 2007, at 20:01 , Postgres User wrote:
> >
> > >>> Yes, I read the manual. I think I had a problem because of the
> > >>> special chars (< / >) that I'm trying to s
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> Magnus Hagander wrote:
>> 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 you're saying we won't
On Aug 23, 2007, at 21:08 , Postgres User wrote:
You're right, that was a typo, I didn't copy and paste.
I found the problem, I was using 2 forward slashes instead of a
backslash + forward slash when pattern matching. The correct regex to
extract my substring:
substring(data_field from '(.+)<
On 8/23/07, Michael Glaesemann <[EMAIL PROTECTED]> wrote:
>
> On Aug 23, 2007, at 20:01 , Postgres User wrote:
>
> >>> 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 Aug 23, 2007, at 20:01 , Postgres User wrote:
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.
Why don't you show us what you've tried and the errors you're
getting? That way we ca
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!
---(end of
-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
> > 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.
>
> Why don't you show us what you've tried and the errors you're
> getting? That way we can help you figure out what you're doing
[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
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
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
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 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
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
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 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
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
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 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 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 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 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
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
>- 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)
>
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
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
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:/
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
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
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
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
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
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
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
-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 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[])
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 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
-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
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
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
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
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
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: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
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 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
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 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
-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
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
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
--- 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
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
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
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
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
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
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
-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
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
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
"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
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
-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
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
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)-
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
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
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
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
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
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
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
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
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
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
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
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
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 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
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
>
> 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
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
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.
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 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
--- 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
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
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
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
>
> > 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
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
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
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
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
1 - 100 of 111 matches
Mail list logo
