Title: notifications:Urgent help needed!!
Hi All,
I’m new to Postgresql and using version 7.2.4.
I want to get notification from backend when a specific error message (like low space) comes to the front end.
How should I specify ‘Notify’ and ‘Listen’ condition?
Thx. In advance.
Anagha
Thanx for the quick response.
checking for readline... no
readline library not found
I have gnu readline 4.1 installed and can find libs in
/usr/local/lib/libreadline.a and headers in
/usr/local/lib/include/readline/*.h.
I configured with ./configure
--with-includes=/usr/local/lib:/usr/local
John McGloughlin <[EMAIL PROTECTED]> writes:
> checking for readline... no
> readline library not found
> I've gone through config.log and it looks like it searches the correct
> locations.
"not found" in this context would probably be better read as "something
went wrong but I dunno what". A l
Hello,
I'm having trouble with ./configure for Postgres 7.3.3 on a RH7.3 i686
system.
checking for readline... no
readline library not found
if you have readline already installed .
I've gone through config.log and it looks like it searches the correct
locations.
I have gnu readline 4
Charles Hornberger <[EMAIL PROTECTED]> writes:
> Other things I perhaps ought to mention: Trying to stop the postmaster
> using pg_ctl fails (unsurprisingly, since pg_ctl relies on
> /var/pgsql/data/postmaster.pid, which contains a nonexistent PID); I
> haven't tried to start a new postmaster ye
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tuesday 17 June 2003 01:01, [EMAIL PROTECTED] wrote:
> On Tue, Jun 17, 2003 at 12:07:31PM +0530, A.Bhuvaneswaran wrote:
>
> But the problem still is: how to receive the NOTIFY from an php script ?
> which function of the c-client lib can be used for
Other things I perhaps ought to mention: Trying to stop the postmaster
using pg_ctl fails (unsurprisingly, since pg_ctl relies on
/var/pgsql/data/postmaster.pid, which contains a nonexistent PID); I
haven't tried to start a new postmaster yet, because the old backends
are hanging around.
Nor h
I've got what looks like a really strange situation on my hands (or else
I've got a normal situation that I'm looking at strangely): It appears
that the main postmaster process is dead & gone, but I have a bunch of
backends still running.
I can't connect to the database server any more, but a b
Greg Spiegelberg <[EMAIL PROTECTED]> writes:
> I have isolated the table but can't seem to find the info on finding
> the bad row and removing it.
Well, it's not rocket science, you just do trial and error to see which
rows you can select without getting the error. I'd try a SELECT
COUNT(*) first
Gidday all,
I've been thinking about upgrading our Servers from
Redhat 7.1 to Redhat 9.0.
Currently running PostgreSQL 7.3.2 but will be
upgrading to 7.3.3 also.
Does anyone no if there are any issues with Redhat
9.0 and PostgreSQL?
Also Redhat 9.0 comes packaged with their own
patched (re
Greg Spiegelberg <[EMAIL PROTECTED]> writes:
> The problem is that the "VACUUM ANALYZE;" results in a
>ERROR: Memory exhausted in AllocSetAlloc(1048575996)
If you do VACUUM and ANALYZE separately, which part shows the failure?
(I'm betting on ANALYZE.) And have you narrowed down which table
Morning,
I have multiple databases running on a Solaris 9, PostgreSQL 7.3.2
system and nightly I run a process that, for each database, performs
first a "VACUUM ANALYZE;" then runs the vacuumlo on the same database.
The problem is that the "VACUUM ANALYZE;" results in a
ERROR: Memory exhausted
On Tue, 17 Jun 2003, scott.marlowe wrote:
> On Tue, 17 Jun 2003, Mel Jamero wrote:
>
> > to get to the psql interface we execute:
> >
> > psql dbname -U user
> >
> > is it possible to disable the -U option such that a user cannot invoke the
> > privileges of a database superuser such as postgre
Brent,
Sounds like you don't have the runtime linker (ld.so) configured
correctly or don't have your environment setup.
Solaris 8 & 9 has a command, crle, which is similar to the Linux
ldconfig command. I typically add all lib paths to it so I don't have
to worry about setting environment variabl
On Tue, 17 Jun 2003, Mel Jamero wrote:
> to get to the psql interface we execute:
>
> psql dbname -U user
>
> is it possible to disable the -U option such that a user cannot invoke the
> privileges of a database superuser such as postgres?
>
> tried looking up pg_hba.conf regarding 'password' a
to get to the psql interface we execute:
psql dbname -U user
is it possible to disable the -U option such that a user cannot invoke the
privileges of a database superuser such as postgres?
tried looking up pg_hba.conf regarding 'password' authentication, the man
pages and the archives but didn't
On Tue, Jun 17, 2003 at 08:39:00 AM [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] wrote:
|>> > But the problem still is: how to receive the NOTIFY from an php script ?
|>> > which function of the c-client lib can be used for this ?
|>>
|>> If you're talking about a PHP script running under apa
Greetings,
I've been looking for a tool for conversion from MySQL databases to
PostgreSQL. What do you recommend? I found a perl-made tool called My2Pg. Is
it a good choice?
Here is some info from My2Pg header :
# My2Pg: MySQL to PostgreSQL dump conversion utility
#
# (c) 2000,2001 Maxim Rudens
On Tue, Jun 17, 2003 at 05:57:32PM +0530, A.Bhuvaneswaran wrote:
> In php 4.3.0, the function pg_get_notify() can be used to access the
> notifyname and pid of backend process. For details, please refer the below
> link:
aaah. that's what i needed :)
cu
--
--
On Tue, Jun 17, 2003 at 06:08:43AM -0600, scott.marlowe wrote:
> > But the problem still is: how to receive the NOTIFY from an php script ?
> > which function of the c-client lib can be used for this ?
>
> If you're talking about a PHP script running under apache as a module or
> CGI, then you
Hi,
I am trying to start postgres from the command line on Solaris 8. I rebooted my
server and now all i get when i try to start postgres is an error. I listed the error
below.
Is there a way to get postgres to read/reference the libraries correctly? How do i
fix this problem, without rebu
> > LISTEN/NOTIFY is yet another SQL. We can write a rule on an event and let
> > it notify. On the other hand, we can have a while(1) process which keeps
> > listening for that notification ie.. event. Once the event is occured, the
> > listening process would be notified. The listening process
Title: Notification
Hi All,
I’m new to Postgres. I’m using Postgres-7.2.4
Can anybody guide me in detail how ‘NOTIFY-LISTEN’ can be implemented progmatically bet’n frontend and backend?
Help appreciated.
Thx,
Anagha
On Tue, 17 Jun 2003 [EMAIL PROTECTED] wrote:
> On Tue, Jun 17, 2003 at 12:07:31PM +0530, A.Bhuvaneswaran wrote:
>
>
> > LISTEN/NOTIFY is yet another SQL. We can write a rule on an event and let
> > it notify. On the other hand, we can have a while(1) process which keeps
> > listening for that
On Tue, Jun 17, 2003 at 12:07:31PM +0530, A.Bhuvaneswaran wrote:
> LISTEN/NOTIFY is yet another SQL. We can write a rule on an event and let
> it notify. On the other hand, we can have a while(1) process which keeps
> listening for that notification ie.. event. Once the event is occured, the
>
25 matches
Mail list logo