[ADMIN] How to check running database is 32 bit

Hello, I have installed Postgresql 8.2.4 using Tarball on Suse Linux 10.1 (64 Bit). I already had running Postgresql 64 bit under /var/lib/pgsql. I installed 32 bit 2nd Postgresql using Tarball under /usr/local/pgsql. I want to cross check whether it is 32 bit or 64 bit. So how shld I check the

Re: [ADMIN] How to check running database is 32 bit

Στις Πέμπτη 19 Ιούλιος 2007 11:27, ο/η nilesh khode έγραψε: > Hello, > > I have installed Postgresql 8.2.4 using Tarball on Suse Linux 10.1 (64 > Bit). > > I already had running Postgresql 64 bit under /var/lib/pgsql. I installed > 32 bit 2nd Postgresql using Tarball under /usr/local/pgsql. I want

[ADMIN] My mails to the forum get garbled, and a new line is being inserted. Why? How?

Thanks Danny Abraham [EMAIL PROTECTED]

Re: [ADMIN] My mails to the forum get garbled, and a new line is being inserted. Why? How?

Στις Πέμπτη 19 Ιούλιος 2007 12:29, ο/η Abraham, Danny έγραψε: > Thanks > As a first measure, stop posting HTML attachments, and then see how it goes :) > Danny Abraham > > [EMAIL PROTECTED] -- Achilleas Mantzios ---(end of broadcast)--- TIP 2: Do

Re: [ADMIN] pgmemcache

On 18.07.2007 18:46, PostgreSQL Admin wrote: As anyone used pgmemcache? I would like to look more into a but I'm having problems installing the sql. I'm on OS X 10.4 and the sql there are lines causing errors: (e.g. AS '$libdir/pgmemcache', 'memcache_server_add' LANGUAGE 'C' STRICT;) thank

Re: [ADMIN] How to check running database is 32 bit

Could I just suggest that you upgrade to 10.2? 10.1, especially the 64 bit version, is a bit rough in places. Steve. On Thu, 19 Jul 2007 01:27:26 -0700 (PDT) nilesh khode <[EMAIL PROTECTED]> wrote: > Hello, > > I have installed Postgresql 8.2.4 using Tarball on Suse Linux 10.1 (64 Bit). > > I

Re: [ADMIN] PgAgent Job Scheduling-Backup

Hello All, One silly question ... what are the difference between client and server postgres. Thanks & Regards Jayakumar M DISCLAIMER: This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PR

[ADMIN] Is there a way to run CREATE TABLESPACE within a stored procedure?

Fails on: Cannot run inside a transaction block. Thanks Danny ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate

[ADMIN] Regarding Postgres Monitoring

Dear Sir/Ma'm, We are using Postgres as a database for our application.We are looking for a monitoring tool for Postgres. Can you please provide any information about which is the best monitoring tool to use which gives good results about the performance of postgres.Wehave gone through tools lik

Re: [ADMIN] Regarding Postgres Monitoring

sushma pandey wrote: Dear Sir/Ma'm, We are using Postgres as a database for our application.We are looking for a monitoring tool for Postgres. Can you please provide any information about which is the best monitoring tool to use which gives good results about the performance of postgres.We h

Re: [ADMIN] PgAdmin hang on cancel query

"Ender" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I'm tried to cancel long running query in the PgAdmin. Run query, press > [Cancel query] button and voila. Program stil live but i'm can't run > queries anymore. Run query button still disabled. Close query tool, open > query

[ADMIN] PgAdmin hang on cancel query

Hi, all. I'm tried to cancel long running query in the PgAdmin. Run query, press [Cancel query] button and voila. Program stil live but i'm can't run queries anymore. Run query button still disabled. Close query tool, open query tool and program hang. ---(end of broa

[ADMIN] Opening with Netcore Solutions

Hi We have an opening for Postgres DBA for our mumbai and bangalore office. Candidate should have exp in Postgres as an DBA. Min Exp: 2yrs Work location: Mumbai and Bangalore. Freshers having exp in postgres and want to pursue the career in DBA can also apply. For information about the comp

[ADMIN] ALTER TABLE ADD CONSTRAINT

Hi all, I do it in table synop: ALTER TABLE synop ADD CONSTRAINT estacoes_fk FOREIGN KEY (id_estacao) REFERENCES estacoes Then I check the DDL and it is like this: CONSTRAINT estacoes_fk FOREIGN KEY (id_estacao, id_estacao) REFERENCES estacoes (id_estacao, id_estacao) - Why id_estac

Re: [ADMIN] ALTER TABLE ADD CONSTRAINT

=?ISO-8859-1?Q?Jos=E9_Roberto_Motta_Garcia?= <[EMAIL PROTECTED]> writes: > ALTER TABLE synop > ADD CONSTRAINT estacoes_fk > FOREIGN KEY (id_estacao) > REFERENCES estacoes > Then I check the DDL and it is like this: > > CONSTRAINT estacoes_fk FOREIGN KEY (id_estacao, id_estacao) REFERENCES > e