I'm also using RHEL3 and I couldn't see any value in using the postgres
package that comes with the distribution. I prefer the source tar.gz
archives as it seems easier to stay uptodate. Using them isn't difficult so
if you have problems withyour rpm maybe you should give them a try and go
with
Haron, Charles wrote:
Hello,
I'm using a perl function in my PosgreSQL database to send an email.
However, field data containing single quotes causes the function to fail.
I'm having trouble escaping the quotes. Sample function definition follows.
You escape single quotes in PostgreSQL with 2 sing
Hello,
I'm using a perl function in my PosgreSQL database to send an email.
However, field data containing single quotes causes the function to fail.
I'm having trouble escaping the quotes. Sample function definition follows.
If company_name is Bob's Fixit, the function will fail.
CREATE OR R
Gaurav Arora wrote:
>I am sorry about my previous mail. The Linux I am
> using is actually Red Hat Enterprise Linux WS release
> 3.
That makes things easier...
Check your install CDs for rh-postgresql* packages. I don't recall if
RH dropped PG from the WS releases, but they *do* include it i
Hi,
did you asked the server to reload configuration
files with a restart or a "pg_ctl reload" ?
lj
- Original Message -
From:
Devi Munandar
To: pgsql-admin@postgresql.org
Sent: Tuesday, January 18, 2005 11:22
AM
Subject: [ADMIN] can't remote access
Hello,
I am running AOLserver with postmaster connecting to my PostgreSQL DB
backend, and recently ran into a problem restarting my server, to which I
used a kill -9 on my AOLserver processes ($ kill -9 nsd) to release the
bound IP.
The problem now is that, when I start the server up again, it is
In the October 2004 thread "postmaster stopps" Tom Lane et al.
suggested better logging to capture error messages when postmaster
silently stops after starting. I was getting silent stops whenever
booting the host, so I tried to follow that advice. I found that
redirecting the standard and erro
hi,
I am sorry about my previous mail. The Linux I am
using is actually Red Hat Enterprise Linux WS release
3.
And I am trying to instal postgres 7.3 on it and
when I try to instal postgresql-7.3-2PGDG.i386.rpm, it
says libpq.so.2 is missing. Any help will be greatly
appreciated.
Thanks i
Gaurav Arora wrote:
> I am a newbie and am trying to instal PostgreSQL 7.3
> on Redhat 9.0 distribution.
RH9 shipped with PG 7.3.2, and there was at least one update (to
7.3.4). You probably want a slightly newer version than that; and
since RHEL3 is (IIRC) based on RH9 fairly closely you shou
hi all
I am a newbie and am trying to instal PostgreSQL 7.3
on Redhat 9.0 distribution.
When I try to instal postgresql-7.3-2PGDG.i386.rpm,
it shows me that I do not have libpq.so.2 package.
Please help.
Regards
Gaurav Arora
__
Do you Yahoo
On Thu, Jan 20, 2005 at 10:33:00AM +0100, Düster Horst wrote:
> I work with PostGIS. To update PostGIS you need to replace different
> functions, operators etc. for it it exists an update process which
> expect the use of a TOC list. I think the best way is to patch this
> pg_restore bug
I'm sure
On Thu, 2005-01-20 at 06:58, Troyston Campano wrote:
> I guess what I am concerned about *is* running on a production server more
> than a test server. Basically, I'd be taking a couple applications that are
> running on the Oracle database instance, building a Postgresql instance, and
> migrating
On Wed, 2005-01-19 at 23:03, Troyston Campano wrote:
> Hello,
>
> I am an Oracle DBA and I want do a Postgresql âproof of conceptâ at
> the large corporation where I work to test the benefits of using
> Postgresql in our environment. I want to install Postgresql onto a
> âproductionâ server that
It depends how you have your Oracle instance configured. If you have
it set up so that the total SGA and UGA ammount consume around 80%-90%
of total available memory, then this is obviously only going to leave
postgress with 20% or less of the total available memory. Postgres is
also designed to
On Thu, Jan 20, 2005 at 08:03:42AM -0500, Troyston Campano wrote:
> Basically, we want to take 3 of the 10 applications running on Oracle, move
> them to Postgresql on the same computer/server and just make sure it runs
> about the same (really speed, memory usage, and space are the big issues).
>
Joost Kraaijeveld wrote:
> Is it possible to run an arbitrary external program on my Linux
> machine if a trigger fires?
Sure, just have the trigger procedure call the external program. The
untrusted languages can do that, or if you want to go barebones, try
PL/sh (http://developer.postgresql.o
Basically, we want to take 3 of the 10 applications running on Oracle, move
them to Postgresql on the same computer/server and just make sure it runs
about the same (really speed, memory usage, and space are the big issues).
I'm not concerned with how hard the migration will be and things like that
I guess what I am concerned about *is* running on a production server more
than a test server. Basically, I'd be taking a couple applications that are
running on the Oracle database instance, building a Postgresql instance, and
migrating them to that postgresql database instance. I'm just wondering
Hi all,
Is it possible to run an arbitrary external program on my Linux machine if a
trigger fires?
Groeten,
Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
e-mail: [EMAIL PROTECTED]
web: www.askesis.nl
There exists a second reason to walk my way. I work with PostGIS. To update
PostGIS you need to replace different functions, operators etc. for it it
exists an update process which expect the use of a TOC list. I think the
best way is to patch this pg_restore bug
-
Troyston Campano <[EMAIL PROTECTED]> wrote on 20.01.2005,
06:03:28:
> I am an Oracle DBA and I want do a Postgresql 'proof of concept' at the
> large corporation where I work to test the benefits of using Postgresql in
> our environment. I want to install Postgresql onto a "production" server
> th
Thanks in advance,
I have a situation where i have to make my client synchronize their entries
made in the database locally with the database in the server and viceversa.
Is there any stable application on this. I use postgresql 7.4.1 version
Lakshmi Narayanan
---(end o
On Thu, Jan 20, 2005 at 08:47:13AM +0100, Düster Horst wrote:
> >Are you sure reordering was necessary? Did you try to restore
> >without reordering the objects?
>
> Yes I tried the restore without reordering, but it doesn't work due to the
> fact that pg_restore tries to restore some objects of
On Thu, 20 Jan 2005 00:03:28 -0500, Troyston Campano
<[EMAIL PROTECTED]> wrote:
>
> Hello,
>
> I am an Oracle DBA and I want do a Postgresql 'proof of concept' at the
> large corporation where I work to test the benefits of using Postgresql in
> our environment. I want to install Postgresql onto
24 matches
Mail list logo
