[ADMIN] Installed OpenSSL but still cannot install PostgreSQL
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 I try to make postgresql7 from the ports collection I'm told: This port requires the OpenSSL library, which is part of the FreeBSD crypto distribution but not installed on your machine. Not sure what to do next. Tamir ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[ADMIN] ERROR message improvement..
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 ? Regds Mallah. -- Rajesh Kumar Mallah, Project Manager (Development) Infocom Network Limited, New Delhi phone: +91(11)6152172 (221) (L) ,9811255597 (M) Visit http://www.trade-india.com , India's Leading B2B eMarketplace. ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [ADMIN] Installed OpenSSL but still cannot install PostgreSQL
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 past the message below. If anyone TH has an idea why I'm still being asked to install OpenSSL when I did I would TH be greatly aided. what is the output of 'ldconfig -r | grep crypt' ? Sincerely, D.Marck [DM5020, DM268-RIPE, DM3-RIPN] *** Dmitry Morozovsky --- D.Marck --- Wild Woozle --- [EMAIL PROTECTED] *** ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [ADMIN] Problems with pg_restore
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) $pg_restore -Ft DBN.dump -d DataBaseName But then I get this message: pg_restore: [archiver] out of memory Is there any workaround? Didn't see any other response to this, I'd suggest using pg_dump's -h option to point the pg_dump on your linux box to your win2k server and dump it directly. You might want to send a message to the -cgwyn group, I'm wondering if there are incompatibilities between windows/linux tar dumps. Robert Treat ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [ADMIN] Installed OpenSSL but still cannot install PostgreSQL
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 I try to make postgresql7 from the ports collection I'm told: This port requires the OpenSSL library, which is part of the FreeBSD crypto distribution but not installed on your machine. Not sure what to do next. 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 -- Sean Chittenden ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [ADMIN] MS SQL 2K replication/backup
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 live. What I would like to do is set up a script to replicate/dump the tables once a night, but I'm not having any luck. With this scenario this PostGreSQL database could then be a sort of backup also. Would it be possible, if needed to push these databases back into MS SQL? I have been going through the archives for a couple of days, but most posts seem to be about real time replications. Any help would be appreciated. You need to do some searching on porting from sql server to postgresql, since this has been tackled before but more likely in that context. There is also an article on techdocs.postgresql.org regarding pulling data from m$sql for use in postgresql. IIRC the postgresql insert based dump in plain text format can be used to push data back into m$sql, though it would depend on how obtuse your database schema is. Robert Treat ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [ADMIN] ¿What's wrong?
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] ~/basicportal/db $ Ipc-daemon $ postmaster -i -D data LOG: database system was shut down at 2003-03-17 21:57:41 LOG: checkpoint record is at 0/83B1A8 LOG: redo record is at 0/83B1A8; undo record is at 0/0; shutdown TRUE LOG: next transaction id: 480; next oid: 16976 LOG: database system is ready And the postgres hang it. Then I do a fast shutdown by ctrol+C, exit cygwin and try again. But the same ocurs. I try to delete the data directory in cygwin (using rm and rmdir) and initdb again the database, but the same ocurrs. I saw the Admnistrator Guide, Manual and the User Guide than but, I don't find what's wrong. There is an up to date set of cygwin install instructions available at: http://www.tishler.net/jason/software/postgresql/postgresql-7.3.2.README If you still can't get it, try posting to the cygwin list. Robert Treat ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[ADMIN] pg_dump problem
Hi all, i have a problem dumping the database containing blobs. The databasehas pdf files stored in one of the tablesand 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 -a -b -Ft -f bdata_030321.tar -vmydb ... pg_dump: [tar archiver] could not write to tar member (wrote 872, attempted 8191) It's not a matter of available disk space, there's plenty of it. I'm using PostgreSQL 7.2.2on Red Hat 8.0 Help, please! T.
Re: [ADMIN] 7.3.2 strange behavior (long)
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 application on pgsql 7.3.2 when a strange thing happen. The machine hangs (not only postgres) after I submit via psql this query update coop_uni set msg_quote='' to the server. The structure of this table is: snip When i try to manually reboot the box I have another problem. the machine hangs during the boot with this message: Unable to handle kernel paging request at virtual address dc7d00 printing eip: c01ad272 * pde = 17edb... Oops: 000 CPU: 0 snip The developing box is a small machine (celeron 1.2GHZ,ram 384MB, no scsi disks and PGDATA is on one ide disk), the kernel version is 2.4.20 I wanted to ask to you if this problem can have had to a hardware issue or to something else. I'm almost certain you have some kind of hardware issue, though unfortunately I can't deduce just what it is. I'd start with checking your ram, then maybe hdd. HTH. Robert Treat ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [ADMIN] Installed OpenSSL but still cannot install PostgreSQL
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 asked to install OpenSSL when I did I would be greatly aided. -Original Message- From: Tamir Halperin Sent: Monday, March 24, 2003 4:43 AM To: [EMAIL PROTECTED] Subject: [ADMIN] Installed OpenSSL but still cannot install PostgreSQL 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 I try to make postgresql7 from the ports collection I'm told: This port requires the OpenSSL library, which is part of the FreeBSD crypto distribution but not installed on your machine. Not sure what to do next. Tamir ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [ADMIN] what its better seqscan or indexscan
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)--- TIP 4: Don't 'kill -9' the postmaster
Re: [ADMIN] Installed OpenSSL but still cannot install PostgreSQL
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] Sent: Monday, March 24, 2003 6:38 AM To: Tamir Halperin Cc: [EMAIL PROTECTED] Subject: Re: [ADMIN] Installed OpenSSL but still cannot install PostgreSQL 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 past the message below. If anyone TH has an idea why I'm still being asked to install OpenSSL when I did I would TH be greatly aided. what is the output of 'ldconfig -r | grep crypt' ? Sincerely, D.Marck [DM5020, DM268-RIPE, DM3-RIPN] -- -- *** Dmitry Morozovsky --- D.Marck --- Wild Woozle --- [EMAIL PROTECTED] *** -- -- ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [ADMIN] Installed OpenSSL but still cannot install PostgreSQL
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/ports/Mk/bsd.port.mk around line 930
.if defined(USE_OPENSSL)
.if ${OSVERSION} = 400014
.if !exists(/usr/lib/libcrypto.so)
.BEGIN:
@${ECHO_CMD} This port requires the OpenSSL library, which is part of
@${ECHO_CMD} the FreeBSD crypto distribution but not installed on your
You may try to play with symlinks, but I suppose more natural way is to upgrade
your system to at least 4.6 security branch and install OpenSSL from base
system.
Or, you can simply make postgresql port without SSL support:
cd /usr/ports/databases/postgresql7
make WITHOUT_SSL=yes
Sincerely,
D.Marck [DM5020, DM268-RIPE, DM3-RIPN]
*** Dmitry Morozovsky --- D.Marck --- Wild Woozle --- [EMAIL PROTECTED] ***
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Re: [ADMIN] Installed OpenSSL but still cannot install PostgreSQL
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. Here's the output of ldconfig -r | grep crypt: 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 I'm sure there's a solution to using postgresql 7.3.2 with openssl. I just don't have it. -Original Message- From: Dmitry Morozovsky [mailto:[EMAIL PROTECTED] Sent: Monday, March 24, 2003 6:38 AM To: Tamir Halperin Cc: [EMAIL PROTECTED] Subject: Re: [ADMIN] Installed OpenSSL but still cannot install PostgreSQL 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 past the message below. If anyone TH has an idea why I'm still being asked to install OpenSSL when I did I would TH be greatly aided. what is the output of 'ldconfig -r | grep crypt' ? Sincerely, D.Marck [DM5020, DM268-RIPE, DM3-RIPN] -- -- *** Dmitry Morozovsky --- D.Marck --- Wild Woozle --- [EMAIL PROTECTED] *** -- -- ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[ADMIN] what its better seqscan or indexscan
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
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 directory that tells me I need TH to first install openssl. TH TH Here's the output of ldconfig -r | grep crypt: TH 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 TH TH I'm sure there's a solution to using postgresql 7.3.2 with openssl. I just don't have it. Well, thanks for re-checking with ldconfig we can see our OPENSSL_OVERWRITE_BASE did not help. Something is broken during the upgrade. Can you check whether openssl libraries reside only in /usr/local/lib and not in /usr/lib ? BTW, you can look at /var/bd/pkg/pkgname-version/+CONTENTS to see where are the files installed by port reside. also, `pkg_info -W /path/to/the/file' is useful to debug. About your problem: contemporary port building system checks for OpenSSL _only_ in base system directories, particularly /usr/lib/libcrypto.so So, possibly, quick hack like 'ln -s /usr/local/lib/libcrypto.so /usr/lib' may help you. Anyway, please consider upgrading to 4.8 which should be out of door this week. Sincerely, D.Marck [DM5020, DM268-RIPE, DM3-RIPN] *** Dmitry Morozovsky --- D.Marck --- Wild Woozle --- [EMAIL PROTECTED] *** ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [ADMIN] Installed OpenSSL but still cannot install PostgreSQL
-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: 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 directory that tells me I need TH to first install openssl. TH TH Here's the output of ldconfig -r | grep crypt: TH 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 TH TH I'm sure there's a solution to using postgresql 7.3.2 with openssl. I just don't have it. Well, thanks for re-checking with ldconfig we can see our OPENSSL_OVERWRITE_BASE did not help. Something is broken during the upgrade. Can you check whether openssl libraries reside only in /usr/local/lib and not in /usr/lib ? BTW, you can look at /var/bd/pkg/pkgname-version/+CONTENTS to see where are the files installed by port reside. also, `pkg_info -W /path/to/the/file' is useful to debug. About your problem: contemporary port building system checks for OpenSSL _only_ in base system directories, particularly /usr/lib/libcrypto.so So, possibly, quick hack like 'ln -s /usr/local/lib/libcrypto.so /usr/lib' may help you. I can't believe it. After two days of scraping around for why it isn't working and one command later it works! It's amazing what knowledge will do for a person's outlook on life. The above ln command worked and postgresql 7.3.2 is currently installing. Anyway, please consider upgrading to 4.8 which should be out of door this week. This is not the mail list for such a question but since you bring it up, can you point me to a concise documented procedure for upgrading my 4.6 to 4.7 or 4.8? If you prefer, you can post it to freebsd-questions where I will eagerly await your response. Thanks again and again. Tamir Sincerely, D.Marck [DM5020, DM268-RIPE, DM3-RIPN] -- -- *** Dmitry Morozovsky --- D.Marck --- Wild Woozle --- [EMAIL PROTECTED] *** -- -- ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[ADMIN] stable phppgadmin version
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.postgresql.org
Re: [ADMIN] Regular expressions in PostgreSQL
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: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
