Re: [ADMIN] Kill Process ERROR !!!

Aris, aris wendy wrote: Dear master [snip] I want to kill process no 582, I use kill -9 582 but all user become disconnect look at below [snip] how to kill only one process ? TIA try with kill -15 582 it works with postgresql ver 7.2.4 Andrea ---(end of broadcast)---

[ADMIN] installation question

Hi,All I have cygwin installed on my windows XP. I start to install postgresql in a unix way. I did ./configure first. When I typed make to build, it fails to build ..src/backend/port/pg_sema.o, complaining that IPC_CREAT, IPC_EXCL, SETVAL etc. are not declared. Those variables are declared in ..s

Re: [ADMIN] [pgadmin-support] Overloading functions that are used by operators.

Title: Message Ahh, thanks. Was just looking at that.   Well I always thought you could overload functions in this way, however with your example below, although it creates it OK, PostgreSQL (not pgAdmin) gives the error 'ERROR: There is more than one function named textcat'.   As I said,

Re: [ADMIN] [pgadmin-support] Overloading functions that are used by operators.

Title: Message   -Original Message-From: Donald Fraser [mailto:[EMAIL PROTECTED] Sent: 08 July 2003 21:00To: [ADMIN]Cc: [pgADMIN]Subject: [pgadmin-support] Overloading functions that are used by operators. I have a question regarding operators which are causing proble

[ADMIN] Error message using pg_dump with tar format

Hi- I'm getting the following error message: pg_dump: [tar archiver] could not write to tar member (wrote 39, attempted 166) Here are the particulars: -I'm running this command: "pg_dump -Ft prod | prod.dump.tar" (The database is named prod) -The dump gets about 1/4 of the way through, and the

[ADMIN] Postgresql broken with Red Hat 9?

I was using Postgres 7.3.2 and later 7.3.3 on Red Hat 8 and everyhing worked fine. Yesterday we upgraded to Red Hat 9 (with 7.3.3 shipped) and since then I can't connect through TCP/IP to database. I am using latest ODBC drivers. Has Red Hat broken something in this release. I tried putting

Re: [ADMIN] Installazione Postgres

"Monica Robustelli" <[EMAIL PROTECTED]> wrote in Italia: > Ho installato Postgres 7.3.2 su macchina Red Hat 9! > Ho configurato Apache a php correttamente, senza alcun errore! > Adesso non riesco a far comunicare il php con Postgres, ho un errore sulla > connessione! > Questo dipende dalla configur

Re: [ADMIN] Kill Process ERROR !!!

scott.marlowe wrote: Please note that this is not necessarily true. If my server has been up a while and I stop/restart the postmaster, it may have a fairly high id number and it is quite possible that in x number of days time, the children will be created with a wrapped pid which is lower than

Re: [ADMIN] Kill Process ERROR !!!

On Wed, 9 Jul 2003, Terry Hampton wrote: > Andrew Sullivan wrote: > > On Wed, Jul 09, 2003 at 09:52:38AM +, aris wendy wrote: > > > >>I want to kill process no 582, I use kill -9 582 but all user become > >>disconnect look at below > > > > > > Try kill -2. > > > > The "

Re: [ADMIN] Kill Process ERROR !!!

Andrew Sullivan wrote: On Wed, Jul 09, 2003 at 09:52:38AM +, aris wendy wrote: I want to kill process no 582, I use kill -9 582 but all user become disconnect look at below Try kill -2. A The " kill -2 " is much better advice. Might I suggest to all - AVOID the

[ADMIN] Installazione Postgres

Ho installato Postgres 7.3.2 su macchina Red Hat 9! Ho configurato Apache a php correttamente, senza alcun errore! Adesso non riesco a far comunicare il php con Postgres, ho un errore sulla connessione! Questo dipende dalla configurazione del file pg_hba.conf? Cosa devo dichiarare? Devo fare qual

Re: [ADMIN] Kill Process ERROR !!!

Aris, aris wendy wrote: > Dear master [snip] > > I want to kill process no 582, I use kill -9 582 but all user become disconnect look at below [snip] > > how to kill only one process ? > > TIA try with kill -15 it works with postgresql ver 7.2.4 Andrea ---(end