Carlos Ojea Castro wrote:
Hello:
I'm trying to use kylix3 and postgresql 7.4.1.
My distro was Debian Woody, kernel 2.20.
I make the link /usr/local/pgsql/lib/libpq.so pointing to libpq.so.2.2
and connection with my database get fine.
But now, using Debian Sarge Testing, kernel 2.4.27 (I tried
I reconfigured the redhat startup script for postgresql to work with
version 8 and that is working fine.
I thought I could put autovacuum in the startup script and that didn't
cause any problems, but it didn't turn on and I had to start it
manually.
Does anyone know why it didn't catch? I was
On Wed, 2004-11-03 at 12:56 +0100, Carlos Ojea Castro wrote:
I'm trying to use kylix3 and postgresql 7.4.1.
My distro was Debian Woody, kernel 2.20.
I make the link /usr/local/pgsql/lib/libpq.so pointing to libpq.so.2.2
and connection with my database get fine.
But now, using Debian
I'm looking for a function that
returns a md5 encryption for postgreSQL 7.3.4
I've found that this function
exists on version 7.4, butI have had problems installing it on my Windows
XP with Cygwin, so I need to found it for version 7.3
Anyone can help me?
Sorry about my english, i'm
For anyone interested, the below procedure worked well.
Randall
Randall Smith wrote:
I am going to sync a schema in postgres with one in an oracle db. The
tables are simple, but there are 200 of them. I would like to try to
keep the sync lag 1 minute. Here is my idea. Please
Oliver Elphick wrote:
On Wed, 2004-11-03 at 12:56 +0100, Carlos Ojea Castro wrote:
I'm trying to use kylix3 and postgresql 7.4.1.
My distro was Debian Woody, kernel 2.20.
I make the link /usr/local/pgsql/lib/libpq.so pointing to libpq.so.2.2
and connection with my database get fine.
But now,
Tk421 wrote:
I'm looking for a function that returns a md5 encryption for
postgreSQL 7.3.4
I've found that this function exists on version 7.4, but I have had
problems installing it on my Windows XP with Cygwin, so I need to
found it for version 7.3
See contrib/pgcrypto
HTH,
Joe
We currently are running a data intensive web service on a Mac using 4D.
The developers of our site are looking at converting this web service to
PostgreSQL. We will have a backup of our three production servers at our
location. The developers are recommending that I purchase a 2GHz Dual
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
There is no version of this library linked to a newer postgres version.
Symlinking libpq.so.3 to libpq.so.2 doesn't work with 7.4 anymore - at least
not here on my mandrake box.
I found no way to get this working except for compiling a libpq from a
We use PostgreSQL 7.x on both OS X and Linux. We used to run OS X in
production, but due to numerous problems we switched to Linux. OS X
was not stable at all, especially under load. It was also a poor
performer under load or not.
In my tests, a P3/800, 512MB RAM (100MHz bus) was
I've been looking at contrib/pgcrypto but it hasn't any information
about md5 encryption
Víctor Robador Capel
Análisis de Sistemas y Programación
www.creativosdolmen.com
- Original Message -
From: Joe Conway [EMAIL PROTECTED]
To: Tk421 [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent:
Tk421 wrote:
I've been looking at contrib/pgcrypto but it hasn't any information
about md5 encryption
Sure it does. See README.pgcrypto:
SQL FUNCTIONS
=
If any of arguments are NULL they return NULL.
digest(data::bytea, type::text)::bytea
Type is here the algorithm
Hi,
Is there a way to translate information in pg_xlog files to a more
readable format?
Basically we have someone accidentally emptied a text column containing
quite a large amount of text, and unfortunately have no backups. I know
the pg_xlog is for WAL, and probably is not the proper way to
Is there a function that will give me
the number of months, as an integer, in Pg 7.4.x? I found the
date_trunc function but that will return text and I didn't see anything
else?
I have this, but didn't want to duplicate
the work if it wasn't necessary:
(date_part('Year', CURRENT_DATE)
Reynard Hilman wrote:
Hi,
Is there a way to translate information in pg_xlog files to a more
readable format?
Basically we have someone accidentally emptied a text column containing
quite a large amount of text, and unfortunately have no backups. I know
the pg_xlog is for WAL, and
I noticed you ran PostgreSQL on a G4. What version of OS X were you
running? Is it possible the issues you were facing were fixed with the
newer G5 processor?
Jeff Bohmer wrote:
We use PostgreSQL 7.x on both OS X and Linux. We used to run OS X in
production, but due to numerous problems we
I noticed you ran PostgreSQL on a G4. What version of OS X were you
running? Is it possible the issues you were facing were fixed with
the newer G5 processor?
We were using OS X 10.2 in production. We currently use 10.3 for our
development machines.
I would be shocked if a processor could fix
You could create your own function for the conversion, something like:
CREATE OR REPLACE FUNCTION interval2Months(INTERVAL) RETURNS INTEGER LANGUAGE 'sql' IMMUTABLE AS '
SELECT CAST(extract(YEAR FROM $1) * 12 + extract (MONTH FROM $1) AS INTEGER);
';
you call it doing SELECT
Reynard Hilman [EMAIL PROTECTED] writes:
Is there a way to translate information in pg_xlog files to a more
readable format?
Basically we have someone accidentally emptied a text column containing
quite a large amount of text, and unfortunately have no backups.
No, and I don't think it
Well, the whole reason I have asked this question is because my
developer swears by OS X and PostgreSQL. However, I wanted opinions from
other people who have possibly used a similar setup so I can make an
informed decision. I will certainly keep your advice in mind. I guess
the only reason I
On Nov 3, 2004, at 1:33 PM, Jeff Bohmer wrote:
We use PostgreSQL 7.x on both OS X and Linux. We used to run OS X in
production, but due to numerous problems we switched to Linux. OS X
was not stable at all, especially under load. It was also a poor
performer under load or not.
Did you (or
OS 10.3 IMHO is more stable then 10.2. I haven't us OS X in a
production environment only for development. I have yet to have any
problems with it crashing.
I haven't really run any tests to load it down but that's only because
I never expect to use in production. We have far too many IBM
While dealing with filesystem bloat issues, I found a large file
named 43710738, recently updated and sitting in one of my
database directories,
$ ls -lh ../../../data/base/11259315/43710738
-rw---1 dba dba 1016M Nov 3 17:05
../../../data/base/11259315/43710738
... with no
Ed L. [EMAIL PROTECTED] writes:
... with no corresponding entry that I can find in pg_class with
that oid (I thought they were all in there).
Look at relfilenode, not OID.
regards, tom lane
---(end of broadcast)---
TIP
on 11/3/04, Jeff Bohmer [EMAIL PROTECTED] wrote:
We use PostgreSQL 7.x on both OS X and Linux. We used to run OS X in
production, but due to numerous problems we switched to Linux. OS X
was not stable at all, especially under load. It was also a poor
performer under load or not.
In my
In my experience, a G4/1.25GHz computer with standard apple drive was much
faster than the PC (Pentium 2+GHz, don't remember details) we tested running
Linux. Both machines had plenty of RAM, same PostgreSQL settings,
etc. The PC
was much slower than the mac running backup/restore (more than 2x
I have a few high-volume, fairly large clusters that I'm struggling to keep
up 24x7x365. I want to ask for advice from anyone with similar experience
or hard-won wisdom.
Generally these are clusters with 100-200 queries/second, maybe 10GB-30GB of
data (always increasing), and maybe 10%
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Ed L.
Sent: Wednesday, November 03, 2004 5:10 PM
To: [EMAIL PROTECTED]
Subject: [GENERAL] 24x7x365 high-volume ops ideas
I have a few high-volume, fairly large clusters that I'm
struggling to
I am running a web-based accounting package (SQL-Ledger) that supports
multiple languages on PostgreSQL. When a database encoding is set to
Unicode, multilingual operation is possible.
However, when a user's input language is set to say English, and the
user enters data such as 79, the data
On Nov 4, 2004, at 1:24 PM, Edmund Lian wrote:
I am running a web-based accounting package (SQL-Ledger) that supports
multiple languages on PostgreSQL. When a database encoding is set to
Unicode, multilingual operation is possible.
snip /
Semantically, one might expect U+FF17 U+FF19 to be
In my experience, a G4/1.25GHz computer with standard apple drive was
much
faster than the PC (Pentium 2+GHz, don't remember details) we tested
running
Linux. Both machines had plenty of RAM, same PostgreSQL settings,
etc. The PC
was much slower than the mac running backup/restore (more than
31 matches
Mail list logo
