[ADMIN] Installed OpenSSL but still cannot install PostgreSQL

2003-03-24 Thread Tamir Halperin
I have installed openssl-0.9.7a_2 from the ports collection without a glitch. I'm new to this and don't know if simply doing make, make install and make clean is all that is required for getting openssl properly installed. It shows up listed in /var/db/pkg in my FreeBSD 4.6 system. However, when

[ADMIN] ERROR message improvement..

2003-03-24 Thread Rajesh Kumar Mallah
Error message like ERROR: value too long for type character varying(20) shud include for which particular columnn the feild size was exceeded. interpolating from " varying(20) " is not always easy especially when you have my dest feilds with same feild size. is this request logical ? Regd

Re: [ADMIN] Installed OpenSSL but still cannot install PostgreSQL

2003-03-24 Thread Dmitry Morozovsky
On Mon, 24 Mar 2003, Tamir Halperin wrote: TH> > This is because libcrypto had its shlib version bumped from .2 to .3 TH> > after OpenSSL's last round of security bugs. If you symlink TH> > libcrypto.so.2 to libcrypto.so, you should be okay. -sc TH> TH> Done that and I'm still unable to move pas

Re: [ADMIN] Problems with pg_restore

2003-03-24 Thread Robert Treat
On Tue, 2003-03-18 at 08:22, lists wrote: > Hi, > > I've made a dump from PostgreSQL 7.2.2 under Win2k with the command: > > $pg_dump -o -C -b -Ft -i -O -v DataBaseName > DBN.dump > > Then I've tried to restore it to another instalation, in another server > (RedHat 7.3, PostgreSQL 7.2.4)

Re: [ADMIN] Installed OpenSSL but still cannot install PostgreSQL

2003-03-24 Thread Sean Chittenden
> I have installed openssl-0.9.7a_2 from the ports collection without > a glitch. I'm new to this and don't know if simply doing make, make > install and make clean is all that is required for getting openssl > properly installed. It shows up listed in /var/db/pkg in my FreeBSD > 4.6 system. Howeve

Re: [ADMIN] MS SQL 2K replication/backup

2003-03-24 Thread Robert Treat
On Tue, 2003-03-18 at 13:52, Jason M. Kuhlman wrote: > Hello > We would like to expose some data live to the internet, but some of our > departments are deep in MS SQL. I know it's possible to replicate SQL to > PostGreSQL. Our data isn't time sensitive so we wouldn't have to have it > replicate l

Re: [ADMIN] ¿What's wrong?

2003-03-24 Thread Robert Treat
On Wed, 2003-03-19 at 13:53, Miguel Angel Martin wrote:Hello, I'm trying to configure a postgresql database (7.3.2) to use with JSP (developing with Netbeans 3.4) I've installed Cygwin. I had create the database and no problem. But second time, I try to run postgresql: [EMAIL PROTECTED] ~/basic

[ADMIN] pg_dump problem

2003-03-24 Thread Tatiana Motova
Hi all,   i have a problem dumping the database containing blobs.   The database has pdf files stored in one of the tables and when there are let say 10 files in it, pg_dump works perfectly, but when about 400Mb of files are loaded into db, pg_dump fails with the following message:   pg_dump

Re: [ADMIN] 7.3.2 strange behavior (long)

2003-03-24 Thread Robert Treat
On Thu, 2003-03-20 at 08:05, andrea suisani wrote: > Hello, > > Firstly I apologise for my terrible english. > we are using postgresql 7.2.x (currently 7.2.4) > on our production server for last year (and also > we are on suse 7.2). > > Last night i was working on the project for > porting our

Re: [ADMIN] Installed OpenSSL but still cannot install PostgreSQL

2003-03-24 Thread Tamir Halperin
> This is because libcrypto had its shlib version bumped from .2 to .3 > after OpenSSL's last round of security bugs. If you symlink > libcrypto.so.2 to libcrypto.so, you should be okay. -sc Done that and I'm still unable to move past the message below. If anyone has an idea why I'm still being

Re: [ADMIN] what its better seqscan or indexscan

2003-03-24 Thread Stephan Szabo
On Mon, 24 Mar 2003, Mario Alberto Soto Cordones wrote: > what it´s a better use the seqscan or indexscan Neither in general, it depends on the particular query and the number of rows in a table and number of rows you're expecting to return. ---(end of broadcast)---

Re: [ADMIN] Installed OpenSSL but still cannot install PostgreSQL

2003-03-24 Thread Tamir Halperin
1:-lcrypt.2 => /usr/lib/libcrypt.so.2 110:-lcrypto.2 => /usr/local/lib/libcrypto.so.2 111:-lcrypto.3 => /usr/local/lib/libcrypto.so.3 117:-lmcrypt.8 => /usr/local/lib/libmcrypt.so.8 > -Original Message- > From: Dmitry Morozovsky [mailto:[EMAIL PROTECTED] > S

Re: [ADMIN] Installed OpenSSL but still cannot install PostgreSQL

2003-03-24 Thread Dmitry Morozovsky
On Mon, 24 Mar 2003, Tamir Halperin wrote: TH> 1:-lcrypt.2 => /usr/lib/libcrypt.so.2 TH> 110:-lcrypto.2 => /usr/local/lib/libcrypto.so.2 TH> 111:-lcrypto.3 => /usr/local/lib/libcrypto.so.3 TH> 117:-lmcrypt.8 => /usr/local/lib/libmcrypt.so.8 Aha. This seems to be a fault in /usr/po

Re: [ADMIN] Installed OpenSSL but still cannot install PostgreSQL

2003-03-24 Thread Tamir Halperin
After following your instructions regarding the deinstallation of the openssl package and then reinstalling it with make OPENSSL_OVERWRITE_BASE=yes, I still get the same message when executing make in the /usr/ports/databases/postgresql7 directory that tells me I need to first install openssl.

[ADMIN] what its better seqscan or indexscan

2003-03-24 Thread Mario Alberto Soto Cordones
Hi.. what it´s a better use the seqscan or indexscan thank Mario ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [ADMIN] Installed OpenSSL but still cannot install PostgreSQL

2003-03-24 Thread Dmitry Morozovsky
On Mon, 24 Mar 2003, Tamir Halperin wrote: TH> After following your instructions regarding the deinstallation of the TH> openssl package and then reinstalling it with make TH> OPENSSL_OVERWRITE_BASE=yes, I still get the same message when executing TH> make in the /usr/ports/databases/postgresql7 d

Re: [ADMIN] Installed OpenSSL but still cannot install PostgreSQL

2003-03-24 Thread Tamir Halperin
> -Original Message- > From: Dmitry Morozovsky [mailto:[EMAIL PROTECTED] > Sent: Monday, March 24, 2003 7:20 PM > To: Tamir Halperin > Cc: [EMAIL PROTECTED] > Subject: RE: [ADMIN] Installed OpenSSL but still cannot install > PostgreSQL > > > On Mon, 24 Mar 2003, Tamir Halperin wrote: >

[ADMIN] stable phppgadmin version

2003-03-24 Thread Devi Munandar
Ok..Than'k alot .my phppgdmin does work now, and I've passed through to phppgadmin so...there any Idea the stable phpPgAdmin version..? B.R Devi Munandar ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.pos

Re: [ADMIN] Regular expressions in PostgreSQL

2003-03-24 Thread Robert Treat
See chapter 6.6.3. "POSIX Regular Expressions" in the Users Guide Robert Treat On Thu, 2003-03-13 at 20:27, Partho Bhowmick wrote: > Is the regular expression used by Postgres POSIX compliant? > > Regards, > Partho ---(end of broadcast)--- TIP 2: