Re: [ADMIN] Instalacion de Postgresql en Linux con Varios procesadores

2005-06-24 Thread Radu-Adrian Popescu
translation Babel! Sorry I mean Fish! Damn it - Josh! -- Radu-Adrian Popescu CSA, DBA, Developer Aldrapay MD Aldratech Ltd. +40213212243 smime.p7s Description: S/MIME Cryptographic Signature

Re: [ADMIN] reg:postgresql library

2005-06-21 Thread Radu-Adrian Popescu
://gborg.postgresql.org/mailman/listinfo/libpqxx-general to get onto the mailing list. If anybody knows pls help me how to proceed further. Thanks Regards, Sandhya R Regards, -- Radu-Adrian Popescu CSA, DBA, Developer Aldrapay MD Aldratech Ltd. +40213212243 smime.p7s Description: S/MIME Cryptographic

Re: [ADMIN] REMOVE

2005-05-03 Thread Radu-Adrian Popescu
, 2005 5:51 PM To: pgsql-admin@postgresql.org Subject: [ADMIN] REMOVE REMOVE ME FROM YOUR LIST... I am not wanting anymore emails from postgres E-Mail: [EMAIL PROTECTED] Web Site: www.envirosolution.com -- Radu-Adrian Popescu smime.p7s Description: S/MIME Cryptographic Signature

Re: [ADMIN] psql and autocommit

2004-08-23 Thread Radu-Adrian Popescu
thing actually. For what it's worth I also think default client policy may as well be left unchanged, or there will be a lot of baffled people. Regards, -- Radu-Adrian Popescu CSA, DBA, Developer Aldrapay MD Aldratech Ltd. +40213212243 ---(end of broadcast

Re: [ADMIN] SERIAL type not autoincremented

2004-07-02 Thread Radu-Adrian Popescu
are implemented(or so I hear) by select max(column_in_question) + 1. Thanx Michal Take care and do read/search the manual, it's quite good ! Regards, -- Radu-Adrian Popescu CSA, DBA, Developer Aldrapay MD Aldratech Ltd. +40213212243 ---(end of broadcast

Re: [ADMIN] Insert binary data on postgre

2004-06-25 Thread Radu-Adrian Popescu
using Java, check out http://doc.postgresintl.com/jdbc/ch08.html Cheers, -- Radu-Adrian Popescu CSA, DBA, Developer Aldrapay MD Aldratech Ltd. +40213212243 ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate

Re: [ADMIN] Insert binary data on postgre

2004-06-25 Thread Radu-Adrian Popescu
that to make those functions available in VB. Best of luck, -- Radu-Adrian Popescu CSA, DBA, Developer Aldrapay MD Aldratech Ltd. +40213212243 ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your

Re: [ADMIN] Database Encryption (now required by law in Italy)

2004-06-10 Thread Radu-Adrian Popescu
and then decrypt and use the data. - -- Radu-Adrian Popescu CSA, DBA, Developer Aldratech Ltd. +40213212243 -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.3 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFASGTdVZmwYru5w6ERAtCkAJ47bkhYffP3CeehdOKZThhCSoOoJgCfQGU3

Re: [ADMIN] replication/mirror

2004-06-03 Thread Radu-Adrian Popescu
-questions.html Regards, -- Radu-Adrian Popescu CSA, DBA, Developer Aldrapay MD Aldratech Ltd. +40213212243 ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [ADMIN] Reliable database communication - Slightly OT

2004-05-24 Thread Radu-Adrian Popescu
the spread www.spread.org docs already, but maybe one of you has had experience with a situation like this? Kind Regards Craig Love to hear your thoughts on the above, Cheers, -- Radu-Adrian Popescu CSA, DBA, Developer Aldrapay MD Aldratech Ltd. +40213212243 ---(end of broadcast

Re: [ADMIN] problem trying to su - postgres

2004-05-07 Thread Radu-Adrian Popescu
postgresql from there (rpm -i postgresql-*.rpm). Have you checked the docs on the main website yet ? | An help would be greatfully received. | | Thanks | | *Neil Thompson | Analyst/Programmer* | Regards and best of luck, - -- Radu-Adrian Popescu CSA, DBA, Developer Aldratech Ltd. +40213212243

Re: [ADMIN] problem trying to su - postgres

2004-05-07 Thread Radu-Adrian Popescu
/etc. | Thank You | Cheers | Neil Thompson | | -Original Message- | From: Radu-Adrian Popescu [mailto:[EMAIL PROTECTED] | Sent: 07 May 2004 10:30 | To: [EMAIL PROTECTED] | Cc: [EMAIL PROTECTED] | Subject: Re: [ADMIN] problem trying to su - postgres | | | [EMAIL PROTECTED] wrote: | | I'm

Re: [ADMIN] freebsd performance

2004-05-03 Thread Radu-Adrian Popescu
)--- | TIP 9: the planner will ignore your desire to choose an index scan if your | joining column's datatypes do not match | | - -- Radu-Adrian Popescu CSA, DBA, Developer Aldratech Ltd. +40213212243 -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.3 (GNU/Linux) Comment: Using GnuPG with Mozilla

Re: [ADMIN] plpgsql editor(s)?

2004-04-02 Thread Radu-Adrian Popescu
, You might want to try nedit - pretty light and highly customisable, X11/Motif, regexp syntax colouring. If you do come up with a proper plpgsql colourisation scheme, do share it :-) ! Cheers, - -- Radu-Adrian Popescu CSA, DBA, Developer Aldratech Ltd. +40213212243 -BEGIN PGP SIGNATURE

Re: [ADMIN] Best Platform for postgres.

2004-04-01 Thread Radu-Adrian Popescu
$. Cheers, - -- Radu-Adrian Popescu CSA, DBA, Developer Aldratech Ltd. +40213212243 -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.3 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFAbEu6VZmwYru5w6ERAkTUAJ0f0bzr0ybp+onLMi94mHW+PmFBegCfbb+q Rc6yVvRtSx1AlmtQ2qXnCvM= =gTQO

Re: [ADMIN] License for PostgreSQL for commercial purpose

2004-03-26 Thread Radu-Adrian Popescu
couldn't resist. Cheers, - -- Radu-Adrian Popescu CSA, DBA, Developer Aldratech Ltd. +40213212243 -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.3 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFAZF2TVZmwYru5w6ERAsL4AJsH8ap61BO6i7i5dJ0rDmWFQ9270ACglcUL fuQ

Re: [ADMIN] Database Encryption (now required by law in Italy)

2004-03-05 Thread Radu-Adrian Popescu
; such as customer's names, addresses, social data, payment data and so on. On the other hand, I think you should be doing this anyway. I know we are :-) Regards, - -- Radu-Adrian Popescu CSA, DBA, Developer Aldratech Ltd. +40213212243 -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.3 (GNU/Linux) Comment

Re: [ADMIN] encrypt function

2003-10-20 Thread Radu-Adrian Popescu
See when your friends are online with MSN Messenger 6.0. Download it now FREE! -- Radu-Adrian Popescu CSA, DBA, Developer Aldratech Ltd. +40213212243

Re: [ADMIN] postgresql having trouble under load

2003-10-20 Thread Radu-Adrian Popescu
Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly -- Radu-Adrian Popescu CSA, DBA, Developer Aldratech Ltd. +40213212243

Re: [ADMIN] IMPORTANT:migration de mysql =postgresql

2003-06-19 Thread Radu-Adrian Popescu
(most) of IT people, and that's English. Cheers, ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html -- Radu-Adrian Popescu CSA, DBA, Developer Aldratech Ltd

Re: [ADMIN] IMPORTANT:migration de mysql =postgresql

2003-06-19 Thread Radu-Adrian Popescu
part. Cheers. -- Radu-Adrian Popescu CSA, DBA, Developer Aldratech Ltd. ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [ADMIN] IMPORTANT:migration de mysql =postgresql

2003-06-19 Thread Radu-Adrian Popescu
At 6/19/2003 11:14, scott.marlowe wrote: On Thu, 19 Jun 2003, Radu-Adrian Popescu wrote: Sachant que quand je crée un rapport j'ai entre 100 et 600 requetes That sounds a bit strange; you mean the report comprises between 100 and 600 requests to the database ? Queries ? Then perhaps you

Re: [ADMIN] client connection

2002-03-13 Thread Radu-Adrian Popescu
On Wed, 2002-03-13 at 03:33, Gill, Jeffrey L wrote: I am trying to make my first connection from a client machine to a postresql server machine. What is the correct client command syntax to connect to the server? I do not want to attempt encryption yet so I am not using SSH or stunnel

Re: [ADMIN] starting log problems

2002-02-06 Thread Radu-Adrian Popescu
My postmaster is started with :su -l postgres -s /bin/sh -c "/usr/local/pgsql/bin/pg_ctl -D $PGDATA -o "-i" -p /usr/local/pgsql/bin/postmaster start /var/log/pgsql 21" /dev/null This is an excerptfrom my data/postgresql.conf file, that sets (some) logging parameters :## Debug

[ADMIN] Regression tests failed on 7.2rc2

2002-01-31 Thread Radu-Adrian Popescu
Hi all. I have built "PostgreSQL 7.2rc1 on i686-pc-linux-gnu, compiled by GCC 3.0.2" a few days ago. After the build was done, i made the regression tests and some (15 or so) failed; i do recall the index test failed. I have been using PosgreSql forsome time and this build seems to be

Re: [ADMIN] Regression tests failed on 7.2rc2

2002-01-31 Thread Radu-Adrian Popescu
Sorry i made a mistake, i'm using rc1 as stated in the email body. - Original Message - From: Radu-Adrian Popescu To: [EMAIL PROTECTED] ; [EMAIL PROTECTED] Sent: Thursday, January 31, 2002 17:36 Subject: [ADMIN] Regression tests failed on 7.2rc2 Hi all

Re: [ADMIN] Backup database through web and php

2002-01-29 Thread Radu-Adrian Popescu
You couldset the authentification methodto "trust"for the host the script is being run from, so you won't get a password prompt at all (see the pg_hba.conf file). - Original Message - From: Lau NH To: [EMAIL PROTECTED] ; [EMAIL PROTECTED] Sent: Tuesday, January 29,

Re: [ADMIN] Maximum Performance Follow-up Question

2002-01-25 Thread Radu-Adrian Popescu
what i understood from the docs. -- Radu-Adrian Popescu CSA, DBA, Programmer ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

[ADMIN] Max. connections overload

2002-01-24 Thread Radu-Adrian Popescu
missing smth here, or doing it all wrong ? I know Bruce Momjian has some good articles on pgsql optimization, and they have been usefull so far, so don't send me back to those. I'd like some guru/expert opinion here, about real system/db administration. Regards, -- Radu-Adrian Popescu CSA

Re: [ADMIN] Maximum Performance

2002-01-24 Thread Radu-Adrian Popescu
, use RedHat's kernels !) will send backends to both processors. Also you should note that *any* program that forks or creates threads on a SMP machine will be able to use (all) the processors. -- Radu-Adrian Popescu CSA, DBA, Programmer ---(end of broadcast

Re: [ADMIN] Maximum Performance

2002-01-24 Thread Radu-Adrian Popescu
) estimation use du -h . Hope that helps. Make sure the amount of shram you get thru your kernel is enough, but not large enough to prevent everything else run :-) -- Radu-Adrian Popescu CSA, DBA, Programmer ---(end of broadcast)--- TIP 1: subscribe

[Fwd: Re: [ADMIN] \d command]

2002-01-22 Thread Radu-Adrian Popescu
-Forwarded Message- From: Radu-Adrian Popescu [EMAIL PROTECTED] To: Jodi Kanter [EMAIL PROTECTED] Subject: Re: [ADMIN] \d command Date: 22 Jan 2002 18:05:19 +0200 With debugging enable and tailing log/pgsql, here it is : SELECT c.relname as Name, CASE c.relkind WHEN 'r' THEN 'table