Re: [ADMIN] need libraries to complete PostgreSQLinstall

2004-05-03 Thread scott.marlowe
On Fri, 30 Apr 2004, kandiah ratnavale wrote: > unable to complete install of PosrtgreSQL without undernoted libraries > > libcrypto.so.2 > libssl.so.2 > > need assistance to locate these libraries for download?? > > earlier request of few days ago not responded to!!

Re: [ADMIN] installation of postgresql-7.2.3-2PGDG

2004-05-03 Thread Jim Seymour
kandiah ratnavale <[EMAIL PROTECTED]> wrote: > > I downloaded postgresql (client, server and libs) but cannot complete > installation for want of the libraries listed below > > libcrypto.so.2 is needed by postgresql-7.2.3-2PGDG > libssl.so.2 is needed by postgresql-7.2.3-2PGDG

Re: [ADMIN] windows-1250 encoding

2004-05-03 Thread Peter Eisentraut
Martin Zdila wrote: > How can one set character encoding in the database to windows-1250? Evidently you cannot. > I just need to order selected rows by some column witch windows-1250 > encoded text. If you have windows-1250 data on the client side, then declare your client encoding, create your

Re: [ADMIN] installation of postgresql-7.2.3-2PGDG

2004-05-03 Thread Peter Eisentraut
kandiah ratnavale wrote: > I downloaded postgresql (client, server and libs) but cannot complete > installation for want of the libraries listed below > > libcrypto.so.2 is needed by postgresql-7.2.3-2PGDG > libssl.so.2 is needed by postgresql-7.2.3-2PGDG > libcrypto.so.2

Re: [ADMIN] Bad character data

2004-05-03 Thread douglas morrison
The lack of responses is prolly because this sort of thing is usually handled by the client... The client for input should be stripping/converting to ASCII/unicode whichever chars are unwanted and notifying the user if anything is removed/unusable. The client for display should then be able to

Re: [ADMIN] Bad character data

2004-05-03 Thread Noah Davis
Hi Doug, Thanks for the response. I do realize it's not the ideal situation, but it's the database I inherited, so not much I can do there :) . I tried the to_ascii and it doesn't seem to help much. It may be that I can try a different client and get more legible characters. Not sure. -Origin

Re: [ADMIN] Anyone using pgreplicator?

2004-05-03 Thread Schaffer, Asher
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I haven't used it, but if you see everything reaching the server is it possible that a commit isn't occurring? UPDATE UPDATE UPDATE ROLLBACK. Is autocommit on? Even if it is on, it is possible that however PgReplicator functions turns off autocomm

[ADMIN] Error when invoking the postmaster

2004-05-03 Thread Christian Medins
I'm attempting to invoke the postmaster through the cygwin unix emulater on windows and I keep getting the following error in the log: FATAL: /bin/postmaster: could not locate postgres executable I've checked and the postgres executable is where is should be in /bin. Does anybody have any sug

[ADMIN] CLUSTER not working

2004-05-03 Thread Steve
Hi, I've been trying to cluster some large tables (more than 10 million records) and this is the error I keep getting: "ERROR: expected both swapped tables to have TOAST tables" and it just stops! Please can someone explain what this means? How do I fix it? I can find *no* reference whatsoever on

[ADMIN] windows-1250 encoding

2004-05-03 Thread Martin Zdila
Hello How can one set character encoding in the database to windows-1250? I am using postgresql 7.2.1-2woody4 (on debian). create database somedb with encoding = 'windows-1250'; ERROR: CREATE DATABASE: invalid backend encoding I just need to order selected rows by some column witch windows-1250

[ADMIN] Help Required.

2004-05-03 Thread sajive.kumar
Title: Help Required. Hi, Is it possible for another database user (not a postgresql superuser ) to start the database. We are facing some problems w.r.t. pg_ctl start by another database user, it says postmaster successfully started FATAL 1:  cannot open /home/sajive/testdb/PG_VERSION

[ADMIN] need libraries to complete PostgreSQLinstall

2004-05-03 Thread kandiah ratnavale
unable to complete install of PosrtgreSQL without undernoted libraries libcrypto.so.2 libssl.so.2 need assistance to locate these libraries for download?? earlier request of few days ago not responded to!! please hurry many thanks, ratnavale -

Re: [ADMIN] Perl stored procedures

2004-05-03 Thread CoL
hi, Rahul k wrote: Im looking for some documentation on writing stored procedures using PL/Perl. The PostrgeSQL tutorials give only a brief introduction to this which is good but enough : http://www.postgresql.org/docs/7.4/static/plperl.html Can anyone pls send any links to more documentation. what

Re: [ADMIN] postgresql 7.4.2 binary for Red Hat Enterprise Linux 2.1

2004-05-03 Thread Mauro Morales M.
See www.postgresql.org and search your OS version. Anycase you can download postgres source and compile. -- Mauro Morales M. mailto:[EMAIL PROTECTED] Linux User # 160358 "Christopher Smith" <[EMAIL PROTECTED]> escribió en el mensaje news:[EMAIL PROTECTED] : Are there any binaries for the Red Hat

[ADMIN] Bad character data

2004-05-03 Thread Noah Davis
I posted this to the pgsql general list, but alas, I did not get any responses. Perhaps someone here could be of assistance? I have a database with some bad characters in it -- some users had entered MS Word smart quotes, em dashes, foreign characters, and they look like gibberish coming out of th

Re: [ADMIN] Creating DB at alternate location

2004-05-03 Thread Peter Eisentraut
Peter Schmid wrote: > Hello all, > > Trying to create a DB at an alternate location fails. I am not > succeding with relativ or absolute path and even not with environment > variables. Also changing from a normal user to root dosn't change > result. What do I wrong. > Can anybody give me a complete

Re: [ADMIN] freebsd performance

2004-05-03 Thread Corey . Brune
Try looking at your kernel- make sure that you don't have any debugging turned on, and comment out all unnecessary devices. Read the man page on tuning. What is slow? Are any metrics at 100%, i.e. IO or CPU? If you need more help, please provide additional information. Corey

[ADMIN] Creating DB at alternate location

2004-05-03 Thread Peter Schmid
Hello all, Trying to create a DB at an alternate location fails. I am not succeding with relativ or absolute path and even not with environment variables. Also changing from a normal user to root dosn't change result. What do I wrong. Can anybody give me a complete command-sequence. System is Sus

Re: [ADMIN] freebsd performance

2004-05-03 Thread Radu-Adrian Popescu
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 pginfo wrote: | Hi all, | | I try to find OS with better performance. | At the mement we are using linux RH AS 3.0 and I think it is not the | best possible. | I'm not into the BSD-vs-Linux thing, but before you consider switching you might want to thin