Hello List,
I currently recompiled postgresql-8.0.1 for Solaris 9, with the
--enable-thread-safety, to appease the install of Slony-I which worked
wonderfully
I used the following configure line:
./configure --enable-thread-safety --without-readline
and the remainder of the defaults were fine
On Tue, Mar 07, 2006 at 05:09:56PM -0500, German Raul Hoyos Parravicino wrote:
> I have a problem developing a ECPG program. I am making a programa using
> FETCH, when the second row is sent the following message appear:
>
> ==>sqlcode [-213] msg[NULL value without indicator in line 1192.]
[...]
>
-- Forwarded message --From: German Raul Hoyos Parravicino <[EMAIL PROTECTED]>Date: Mar 7, 2006 3:36 PM
Subject: QuestionTo: [EMAIL PROTECTED]
Dear Administrator:
I have a problem developing a ECPG program. I am making a programa using FETCH, when the second row is sent the follo
Tom Lane wrote:
Louis Gonzales <[EMAIL PROTECTED]> writes:
I was wondering if anybody has had much experience with postgresql-R,
Postgres-R doesn't exist in any production-ready form. That software
is an academic project that's based on a very old, buggy release of
Post
Louis Gonzales <[EMAIL PROTECTED]> writes:
> I was wondering if anybody has had much experience with postgresql-R,
Postgres-R doesn't exist in any production-ready form. That software
is an academic project that's based on a very old, buggy release of
Postgres ... you *don't* want to use it.
Based on:
Postgres based Replication Projects
PG
Replication
Postgres-R: Dr.
Kemme's Site, Paper,
Publications,
Replication
Work, The
Horus Project and Emsemble
DRAGON:
Database Replication based on Group Communication
The
Slony-1 Project
PGCluster
DBBalancer
On Tue, Mar 07, 2006 at 03:29:37PM -0500, Louis Gonzales wrote:
> Hello,
> I was wondering if anybody has had much experience with postgresql-R, or
> being able to do database replication in a WAN environment.
> Basically, does anybody have any good links/docs on doing this with
> Solaris 9, post
Hello,
I was wondering if anybody has had much experience with postgresql-R, or
being able to do database replication in a WAN environment.
Basically, does anybody have any good links/docs on doing this with
Solaris 9, postgresql v8.0?
Thanks in advance.
begin:vcard
fn:louis
n:gonzales;louis
e
--- Tom Lane <[EMAIL PROTECTED]> wrote:
> It seems risky, but you could probably get away with that as long
> as the database locale (LC_COLLATE/LC_CTYPE) is "C" ... which is really
> the only one that's safe with SQL_ASCII anyway ...
I actually created the cluster with:
test1:~# /usr/lib/postgr
Hello Andy,
Thanks a lot for your answer,
I'll retry with this new information!
I will give you feedback when I would
had made this new way !
Best regard
Fabrice
"Andy Shellam"
<[EMAIL PROTECTED]>
Envoyé par : [EMAIL PROTECTED]
07/03/2006 16:34
Veuillez répondre à
<[EMAIL PROTECTED]
ow <[EMAIL PROTECTED]> writes:
> I see... If *ALL* data is in ASCII, is it possible to just update
> "pg_database.encoding" to UTF-8 or will I need to recreate the db?
It seems risky, but you could probably get away with that as long
as the database locale (LC_COLLATE/LC_CTYPE) is "C" ... which is
--- Tom Lane <[EMAIL PROTECTED]> wrote:
> ow <[EMAIL PROTECTED]> writes:
> > Are there any negative effects related to the selection of UTF-8 over
> SQL_ASCII
>
> There will be a speed penalty; whether it's significant in your
> application is something you can only determine by experiment.
I
If you do "ps auxwww|grep postgres" on your console command
line - you should find processes with a status of "IDLE IN TRANSACTION" or
similar, and use that data and the PG server status to identify where it
came from, and submit a COMMIT or ROLLBACK command on that
connection.
From: [EMAI
Hello Tom Lane,
Thank you very much for your answer!!
My PG version is older than 7.3 , I
know it so old and so much old.. but I can't update this version... :-((
However, could you explain me how I
can close open transaction?
Thanks in advance!!
best regard
Fabrice
Tom Lane <[EMAIL P
Hi Tom,
On Tue, 2006-03-07 at 10:07 -0500, Tom Lane wrote:
> "Joost Kraaijeveld" <[EMAIL PROTECTED]> writes:
> > Can I safely delete all the WAL log files in PGDATA/pg_xlog directory if
> > the database has been shut down correctly, because I lowered the number of
> > logfiles in postgresql.conf
"Joost Kraaijeveld" <[EMAIL PROTECTED]> writes:
> Can I safely delete all the WAL log files in PGDATA/pg_xlog directory if the
> database has been shut down correctly, because I lowered the number of
> logfiles in postgresql.conf?
All but the one holding the latest checkpoint record (pg_controld
[EMAIL PROTECTED] writes:
> But I had error :"ERROR: Parent tuple was not found
What PG version is this? We recently fixed some bugs that could lead to
this error.
The error could only occur if you have some old open transaction(s) that
could possibly still see since-updated tuples in the vacuu
ow <[EMAIL PROTECTED]> writes:
> Are there any negative effects related to the selection of UTF-8 over
> SQL_ASCII
There will be a speed penalty; whether it's significant in your
application is something you can only determine by experiment.
regards, tom lane
---
Am Dienstag, 7. März 2006 15:08 schrieb ow:
> Are there any negative effects related to the selection of UTF-8 over
> SQL_ASCII (e.g. size of the database, sort/like/group issues, etc)?
If you're only planning to store ASCII data, choosing UTF-8 will not cause any
additional problems. But obviou
"PostgreSQL 8.1.0 on i486-pc-linux-gnu, compiled by GCC cc (GCC) 4.0.3 2005
(prerelease) (Debian 4.0.2-4)"
Hi,
Am having some doubts whether a new db should be with SQL_ASCII or UTF-8
encoding. We expect ALL of our data to be ASCII. At the same time, I guess,
it's possible that some user may
Hi,
Can I safely delete all the WAL log files in PGDATA/pg_xlog directory if the
database has been shut down correctly, because I lowered the number of logfiles
in postgresql.conf?
Groeten,
Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024
Hello,
I executed a Vacuum on my Postgres database.
You can see the command line : /vacuumdb
-f -z -v -d ccm > /tmp/vacuum.txt 2> /tmp/vacuumError.txt I
used performed the vacuum.
But I had error :"ERROR: Parent
tuple was not found
vacuumdb: vacuum ccm failed"
each time I am executed the
22 matches
Mail list logo
