Re: [ADMIN] Installing PostgreSQL as "postgress" versus "root" Debate!

2005-01-29 Thread "Miquel van Smoorenburg"
In article <[EMAIL PROTECTED]>, Goulet, Dick <[EMAIL PROTECTED]> wrote: > Well, someone I can wholeheartedly agree with. So it really does not >matter who owns the binaries. Once the right account gets hacked your >had. If they hack root your dead, if they hack postgres the database is >had alth

[ADMIN] Problem with unicode support

2005-01-29 Thread aromero
Hello, I’ve got a RedHat 7.3 and Postgresql 7.3.5 system installed. When I compiled Postgresql I did it without the option –enable-locale-enable-multibyte. This is why it does not support unicode, and now I need support for unicode. Is there a way to make my system (Postgesql 7.3.5) unicode sup

Re: [ADMIN] Problem with unicode support

2005-01-29 Thread Peter Eisentraut
[EMAIL PROTECTED] wrote: > I’ve got a RedHat 7.3 and Postgresql 7.3.5 system installed. When I > compiled Postgresql I did it without the option > –enable-locale-enable-multibyte. That's irrelevant, because these options do not exist in 7.3. > This is why it does not support > unicode, Nope, Un

Re: [ADMIN] Restore postgres database problem

2005-01-29 Thread Inpreet Singh
Yes it returning carriage returns. I am pasting below the output to the command u send to me ***Linux Prompt** [EMAIL PROTECTED] inpreet]# head postgres.sql | cat -v --^M -- PostgreSQL database cluster dump^M --^M ^M \connect "template1"^M ^M --^M -- Users^M --^M ^M ***

Re: [ADMIN] Restore postgres database problem

2005-01-29 Thread Inpreet Singh
Yes dos2unix worked absolutely fine. I got the solution of my problem. Thanks alot for your co-operation. I am using Linux Red hat 9 and my client is also using the same platform but when he emailed me this sql file he first saved file on windows and then I saved it on windows and saved n run on l

Re: [ADMIN] Restore postgres database problem

2005-01-29 Thread Inpreet Singh
*Taken Dump :* /usr/bin/pg_dumpall > /home/inpreet/postgres.sql /*which was taken at client site*/ *Restoring Dump :* su - postgres /*This process I am doing at local site so thats why psql and dumpall are in diff directories*/ /usr/local/pgsql/bin/psql -d template1 < /home/inpreet/postgres.

[ADMIN] Does anyone have a script to monitor if FSM settings are sufficient?

2005-01-29 Thread Ron Mayer
I may be implementing a database at a customer's site that would ideally run administration free for a year or so -- or at least be able to have scripts detect proactively if they'd need to call us for support before the system starts behaving poorly. Is there a way to parse the output of "vacuum"

Re: [ADMIN] Does anyone have a script to monitor if FSM settings are sufficient?

2005-01-29 Thread Uwe C. Schroeder
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 What I'm doing in a case like that is have the system send a copy of the vacuum etc. messages to my email account. So I check in on those values once in a while and if I think I need to become active I actually call the customer and tell him it's t