Re: [ADMIN] Postgresql 9.0.1 installation error

Hi Craig, Thank you very much for your reply ! Here is my reply - 1. We are using RHEL with the below version Linux version 2.6.18-194.26.1.el5 (mockbu...@x86-004.build.bos.redhat.com) (gcc version 4.1.2 20080704 (Red Hat 4.1.2-48)) #1 SMP Fri Oct 29 14:21:16 EDT 2010 2. LD_LIBRARY_PATH is not

[ADMIN] Postgres process

Hi guys, I need some help discovering the processes that run on an instance. I know that there are many processes running on one instance and they are all called postges, but I was hoping you can help me find a way to uniquely identify each one of them. I want to discover what the process name

Re: [ADMIN] Postgresql 9.0.1 installation error

On 8/08/2011 7:11 PM, Venkat Balaji wrote: We had installed PostgreSQL9.0.1 for which i had executed the below commands - ./configure --with-openssl --prefix=/opt/Postgresql9.0.1/ make install installed successfully OK, you're building Pg from source rather than using packages provided by ED

Re: [ADMIN] pg_dump: Error message from server: ERROR: out of shared memory on one system works fine on another

Tom, That did the trick. I made a bad assumption that the shared_memory was causing the problem and not the other way around. I set it up to 256, last attempt was 128 and it still failed, not sure what value would have given me success (128 - 256) but it needed quite a bit more. Thanks for your

[ADMIN]

Hi, I've been searching a way to fully restore a database with it's roles. I've got a cluster with many db's in which I don't have many privileges in addition. I need to migrate that database to a cluster of our possesion. I've been reading the docs in the section of the catalogs to figure out how

[ADMIN] Re: All the functionality I need is pgsql2shp.exe-- isolated installation

Thank you for the help... I will give this a try! -- View this message in context: http://postgresql.1045698.n5.nabble.com/All-the-functionality-I-need-is-pgsql2shp-exe-isolated-installation-tp4675350p4678033.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com. -- Sent via

[ADMIN] pgsql2shp error when query is introduced

Hi Community, I am trying to create a shp file from the command line by using pgsql2shp for a specific query of an existing database table. I am able to use this command to create a shp without the query where the database name is forGgis and the table name is COVER63p_prj32119: C:\Program Files

Re: [ADMIN] Postgresql 9.0.1 installation error

Nag - Don't conflate concerns over making an SSL connection with making a 'simple' connection; keep it simple first. Then, once you move to SSL, yes - whatever 'client' you're using to connect must have SSL support built in. In some cases, this will be libpq or ecpg . First off, have you read

Re: [ADMIN] Postgresql 9.0.1 installation error

Yes, i can connect from the different bin without any issues, but, may not be able to get the SSL services, since that built is not SSL compiles. Below is the detailed explaination - Here is what i have done - ./configure --with-openssl --prefix=/opt/Postgresql9.0.1/ make install The below bin

[ADMIN] Postgresql 9.0.1 installation error

Hello, This is my first post to the community. We have been widely using PostgreSQL for our production environment. We are pleased with the performance and features of PostgreSQL. We have landed into a problem recently - We had installed PostgreSQL9.0.1 for which i had executed the below comman