Re: [ADMIN] Postgres User Password File????

2007-09-12 Thread Kis János Tamás
péntek 07 szeptember 2007 18.13 dátummal smiley2211 ezt írta: > Hello all, > > Where do I find the PASSWORDs for users on Postgresql??? It seems > connections are failing because user PROOT's password is not > correct - where do I find out what it's set to - do I need to > change it??? > > DataObj

[ADMIN] Error installing Postgres 8.2.4

2007-09-12 Thread Jenny Nickel
Hi, I am getting an error while running gmake on postgres8.2.4. Here is the list of steps that I followed Platform is Solaris 10 for x86 1. Downloaded postgresql-8.2.4.tar from ftp://ftp.postgresql.org/pub/source/v8.2.4/postgresql-8.2.4.tar.gz 2. gunzip postgresql-8.2.4.tar.gz

Re: [ADMIN] out of memory

2007-09-12 Thread Tino Schwarze
On Tue, Sep 11, 2007 at 09:15:56PM -0700, Tena Sakai wrote: > But there's a problem, for which I hope you have > more wisdom. The reason why I tried that query > is because someone tried the same thing via odbc > from pc quering postgres database and got the > same error ("out of memory"). > > W

Re: [ADMIN] Error installing Postgres 8.2.4

2007-09-12 Thread Devrim GÜNDÜZ
Hi, On Wed, 2007-09-12 at 01:04 -0700, Jenny Nickel wrote: > gmake[2]: ar: Command not found Either install ar or if it is installed, add it to your $PATH. Regards, -- Devrim GÜNDÜZ PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosti

Re: [ADMIN] out of memory

2007-09-12 Thread Tom Lane
Tino Schwarze <[EMAIL PROTECTED]> writes: > On Tue, Sep 11, 2007 at 09:15:56PM -0700, Tena Sakai wrote: >> But there's a problem, for which I hope you have >> more wisdom. The reason why I tried that query >> is because someone tried the same thing via odbc >> from pc quering postgres database and

Re: [ADMIN] Error installing Postgres 8.2.4

2007-09-12 Thread Tom Lane
Devrim =?ISO-8859-1?Q?G=DCND=DCZ?= <[EMAIL PROTECTED]> writes: > On Wed, 2007-09-12 at 01:04 -0700, Jenny Nickel wrote: >> gmake[2]: ar: Command not found > Either install ar or if it is installed, add it to your $PATH. A look at the Solaris machines in the build farm suggests that ar is likely t

[ADMIN] Postgres8.2.4 Installation Error

2007-09-12 Thread Jenny Nickel
Hi, I am getting an error while running gmake on postgres8.2.4. Here is the list of steps that I followed Platform is Solaris 10 for x86 1. Downloaded postgresql-8.2.4.tar from ftp://ftp.postgresql.org/pub/source/v8.2.4/postgresql-8.2.4.tar.gz 2. gunzip postgresql-8.2.4.tar.gz

[ADMIN] hi

2007-09-12 Thread IgnatiusRene.Anton
Hi am Ignatius Rene Anton Am trying to install pgadmin3 through maven "pom.xml " . I have included wxWindows libxml and libxslt as dependencies in the pom.xml. I could not install pgadmin3 version 1.6.2 in my machine . I am working in red-hat linux platform 2.4.21-50.ELhugemem . Can you hel

Re: [ADMIN] out of memory

2007-09-12 Thread Tena Sakai
Many thanks, Tom and Tino. Tena Sakai [EMAIL PROTECTED] -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Wed 9/12/2007 7:20 AM To: Tino Schwarze Cc: pgsql-admin@postgresql.org; Tena Sakai Subject: Re: [ADMIN] out of memory Tino Schwarze <[EMAIL PROTECTED]> writes: > O

[ADMIN] how to change the port number for the Postgres server

2007-09-12 Thread Jessica Richard
Everything was running fine under the default number 5432. After the port number was changed to another number in postresql.conf file and the server was restarted, dblink is broken, it is still looking for the old port number 5432... not sure if everything else is broken as well... So, how to

Re: [ADMIN] how to change the port number for the Postgres server

2007-09-12 Thread Joe Conway
Jessica Richard wrote: Everything was running fine under the default number 5432. After the port number was changed to another number in postresql.conf file and the server was restarted, dblink is broken, it is still looking for the old port number 5432... not sure if everything else is broken

Re: [ADMIN] how to change the port number for the Postgres server

2007-09-12 Thread Kevin Kempter
On Wednesday 12 September 2007 11:10:51 Jessica Richard wrote: > Everything was running fine under the default number 5432. After the port > number was changed to another number in postresql.conf file and the server > was restarted, dblink is broken, it is still looking for the old port > number 5

Re: [ADMIN] reindexdb hangs

2007-09-12 Thread Alvaro Herrera
Tom Lane wrote: > Alvaro Herrera <[EMAIL PROTECTED]> writes: > > I am unsure if I should backpatch to 8.1: the code in cluster.c has > > changed, and while it is relatively easy to modify the patch, this is a > > rare bug and nobody has reported it in CLUSTER (not many people clusters > > temp tabl

[ADMIN] automatically detecting long timed locks

2007-09-12 Thread Tino Schwarze
Hi there, is there an easy way to detect locks which are held for a very long time? We've got some problems with a database here where a lock is held for 1 or 2 hours though the operation should be very quick. A lot of other processes are then waiting for the lock to become available. We would li

Re: [ADMIN] automatically detecting long timed locks

2007-09-12 Thread Scott Marlowe
On 9/12/07, Tino Schwarze <[EMAIL PROTECTED]> wrote: > Hi there, > > is there an easy way to detect locks which are held for a very long > time? We've got some problems with a database here where a lock is held > for 1 or 2 hours though the operation should be very quick. A lot of > other processes

Re: [ADMIN] Telecom(Colombia) - Error postgresql

2007-09-12 Thread Alvaro Herrera
DIEGO ARMANDO LOPEZ PINILLA wrote: > De pronto me podrían colaborar con la solución de este inconveniente: > > [EMAIL PROTECTED]:~> pg_dump tollticketing > prueba.backup > > pg_dump: schema with OID 128157747 does not exist El problema es que hay un catalogo que hace referencia a ese schema, qu

[ADMIN] "Failed to connect to the database" error

2007-09-12 Thread Yingqi Tang
All, I am having a problem finishing the installation of postgresql. Everything works fine until "Activating the Procedual Language..." then a dialog with en error message pops up saying that "Failed to connect to the database, Procedual language is installed but not activated", then the installat