Re: [ADMIN] Corrupted data, best course of repair?

aner way to proceed. Tons of corruption and a backup that's a few weeks old. *grin* The most recent dump seems to have all of the data, but some rows are there in duplicate. Thanks for the input. -sc -- Sean Chittenden ---(end of broadcast)---

[ADMIN] Corrupted data, best course of repair?

--- flushed only to 1A1/3A20E26C Aug 21 15:04:33 db postgres[392]: [3-2] CONTEXT: writing block 3415 of relation 1663/17236/70731682 Aug 21 15:04:33 db postgres[392]: [4-1] WARNING: could not write block 3415 of 1663/17236/70731682 Aug 21 15:04:33 db postgres[392]: [4-2] DETAIL:

Re: [ADMIN] Postgresql on software RAID

f RAID 1 is going to be half that of just writing to a single device. SCSI on the other hand... SCSI is the only way to go if you're serious about databases. -sc -- Sean Chittenden ---(end of broadcast)--- TIP 6: Have you searched our li

Re: [ADMIN] No acceptable C compiler found

which cc it found first in my path, but whatever it was, use the other one and you'll get past this (/usr/ucb, iirc... those were dark days that I try to forget) ... if you're on slowaris that is. -sc -- Sean Chittenden ---(end of broadcast)-

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

e 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 ou

Re: [ADMIN] asynchronous psql command options?

utput] exit # the screen session exit # exit ssh -- Sean Chittenden ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [ADMIN] 7.1->7.2 data import timestamp problems

tainer and think that a note regarding this change may come in future versions of the pgsql port. Real quick, FreeBSD is currently building with MIT kerberos support out of the box. Are there any plans to merge in the Heimdal kerberos patches? -sc -- Sean Chittenden ---(en

Re: [ADMIN] 7.1->7.2 data import timestamp problems

you don't have the word 'current' in your dump other than timestamps. grep -i current pgsql_dump.sql HTH -sc -- Sean Chittenden ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [ADMIN] About groups in postgres

: I don't know that there's a way to rescind privs that have been granted to you. -sc -- Sean Chittenden ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PR

Re: [ADMIN] INSERT performace.

10 hours to create the indexes. > > > > Have you tried to escape the data before you inserted it? That > > should've solve things. > > No, how do you do that ? Do you know what those 'strange characters' are? -sc -- Sean Chittenden

Re: [ADMIN] INSERT performace.

though, i like postgres more, mysql is still faster with hugh > (simple) data. I've never found that to be the case in only a few instances actually... and typically with small data sets that are less than 1M rows. vacuum analyze and turn fsync off. :~) -sc -- Sean Chittenden ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [ADMIN] INSERT performace.

age to put 300k > records in ca. 2-3 hours. If possible, use the COPY command. We did 90K rows in about 40sec using this puppy on a Solaris U5 (took over 130sec for MySQL on the same box in case the performance geeks in the crowd are interested). http://www.postgresql.org/idocs/inde