Re: [ADMIN] Installing PostgreSQL Yum Repository

2012-08-19 Thread Devrim GÜNDÜZ
Hi, On Sat, 2012-08-18 at 10:25 -0700, Jonathan Pool wrote: > I am trying to follow the instructions on > http://www.postgresql.org/download/linux/redhat/ for installing the > PostgreSQL Yum Repository (on RHEL 5). > > So I downloaded pgdg-redhat-9.1-4.noarch.rpm into a directory from > http://y

Re: [ADMIN] Installing PostgreSQL Yum Repository

2012-08-18 Thread Jonathan Pool
>> So I downloaded pgdg-redhat-9.1-4.noarch.rpm into a directory from >> http://yum.postgresql.org/9.1/redhat/rhel-5-x86_64/pgdg-redhat-9.1-4.noarch.rpm. >> >> Then I tried to install it with: >> >> rpm -i >> http://yum.postgresql.org/9.1/redhat/rhel-5-x86_64/pgdg-redhat-9.1-4.noarch.rpm > > F

Re: [ADMIN] Installing PostgreSQL Yum Repository

2012-08-18 Thread Craig Ringer
On 08/19/2012 01:25 AM, Jonathan Pool wrote: I am trying to follow the instructions on http://www.postgresql.org/download/linux/redhat/ for installing the PostgreSQL Yum Repository (on RHEL 5). So I downloaded pgdg-redhat-9.1-4.noarch.rpm into a directory from http://yum.postgresql.org/9.1/re

Re: [ADMIN] Installing PostgreSQL

2010-06-02 Thread Scott Marlowe
On Tue, Jun 1, 2010 at 10:01 AM, Daniel, Clyde D (Derrick) wrote: > > Good Afternoon, > > > >     I am trying to install PostgreSQL on my desktop and it is > asking for a password.  Everything I type in is not working . Try a really complex password like: azxygrh123DF$%yhn etc. nu

Re: [ADMIN] Installing Postgresql on Debian (-E parameter question)

2009-07-10 Thread Dimitri Fontaine
Please keep the list in Copy. Le 9 juil. 09 à 23:09, Panos Katergiathis a écrit : Thank you for all this information. Please allow me one more question. How can one detect the -E parameter that was used at the "initdb" stage? That will match the encoding of template0, template1 and postgres

Re: [ADMIN] Installing Postgresql on Debian (-E parameter question)

2009-07-09 Thread Dimitri Fontaine
Hi, Le 9 juil. 09 à 20:57, Panos Katergiathis a écrit : a) Is it still essential to pass the -E proper parameter at the stage of 'initdb' in order to support various encodings fully? Yes. b) If so, how does one pass this parameter when installing from a standard *.deb package (or *.rpm, fo

Re: [ADMIN] Installing PostgreSQL 8.3.3. on Vista

2008-08-29 Thread Brandon Dybala
Steve, That did it. Thanks! Brandon -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steve Holdoway Sent: Thursday, August 28, 2008 4:45 PM To: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Installing PostgreSQL 8.3.3. on Vista Looks like the

Re: [ADMIN] Installing PostgreSQL 8.3.3. on Vista

2008-08-28 Thread Steve Holdoway
Looks like the relevant Visual C runtime library ( VC80.CRT 32 bit ) needs installing first... Steve On Thu, 28 Aug 2008 09:42:54 -0500 "Brandon Dybala" <[EMAIL PROTECTED]> wrote: > I tried installing PostgreSQL 8.3.3 on Vista Business, and initdb failed > to start during the installer. I'd re

Re: [ADMIN] Installing PostgreSQL as Admin

2007-10-30 Thread Alvaro Herrera
Nandakumar Tantry wrote: > Does any-ne know how to install PostgreSQL with > Administrator account? If not how will I do it? Any documentation > available? You can't. -- Alvaro Herrera Valdivia, Chile ICBM: S 39º 49' 18.1", W 73º 13' 56.4" "Puedes elegir el color de tu aut

Re: [ADMIN] Installing PostgreSQL as Admin

2007-10-30 Thread Chris Browne
[EMAIL PROTECTED] ("Nandakumar Tantry") writes: >     Does any-ne know how to install PostgreSQL with > Administrator account? If not how will I do it? Any documentation > available?:p> I believe there is documentation on this matter here: http://pginstaller.projects.postgresql.org/faq/

Re: [ADMIN] Installing PostgreSQL as Admin

2007-10-30 Thread Kevin Grittner
>>> On Tue, Oct 30, 2007 at 7:57 AM, in message <[EMAIL PROTECTED]>, "Nandakumar Tantry" <[EMAIL PROTECTED]> wrote: > Does any-ne know how to install PostgreSQL with > Administrator account? If not how will I do it? That is a very bad idea from a security standpoint, which is why

Re: [ADMIN] Installing postgreSQL

2007-10-08 Thread Scott Marlowe
On 10/8/07, Malm Paul <[EMAIL PROTECTED]> wrote: > > Hi, > I'm trying to install PostgreSQL 8.2.5 on a WIN XP computor. > I have removed the path to cygwin, but It will still not be installed. > > The error I'm getting is: > > Your local 'Administrators' group contains 'Interactive users' > This is

Re: [ADMIN] Installing PostgreSQL admin package

2007-09-13 Thread Shane Ambler
Ashish Karalkar wrote: Hello list, can anybody please point me to phpPgAdmin windows installation package? Thanks in advance With regards Ashish... I don't think there is a specific windows installer. phpPgAdmin is a web based admin gui, you will need to have a web server running on the wi

Re: [ADMIN] Installing PostgreSQL admin package

2007-09-13 Thread Josh Trutwin
On Thu, 13 Sep 2007 18:27:54 +0530 "Ashish Karalkar" <[EMAIL PROTECTED]> wrote: > Hello list, > > can anybody please point me to phpPgAdmin windows installation > package? http://phppgadmin.sourceforge.net/?page=download download the .zip Assuming you have a Windows web server. phpPgAdmin is

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

Re: [ADMIN] installing postgreSQL 7.3 on Redhat ?

2005-01-20 Thread Kris Deugau
Gaurav Arora wrote: > I am a newbie and am trying to instal PostgreSQL 7.3 > on Redhat 9.0 distribution. RH9 shipped with PG 7.3.2, and there was at least one update (to 7.3.4). You probably want a slightly newer version than that; and since RHEL3 is (IIRC) based on RH9 fairly closely you shou

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

2005-01-14 Thread Goulet, Dick
-Original Message- From: Scott Marlowe [mailto:[EMAIL PROTECTED] Sent: Thursday, January 13, 2005 12:19 PM To: Dawid Kuroczko Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Installing PostgreSQL as "postgress" versus "root" On Thu, 2005-01-13 at 06:41, Dawid Kuroczko wrot

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

2005-01-13 Thread Geoffrey
Tomeh, Husam wrote: Wouldn't installing postgreSQL as postgres give me the convenience to upgrade PostgreSQL and the database without having the SA get involved. Is it a question of roles now? Should a DBA perform all postgreSQL-related tasks or should that the accountability be confused by havin

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

2005-01-13 Thread Tomeh, Husam
an Cc: PostgreSQL Admin Subject: Re: [ADMIN] Installing PostgreSQL as "postgress" versus "root" Debate! -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Thursday 13 January 2005 01:44 pm, Bruce Momjian wrote: > Uwe C. Schroeder wrote: > [ PGP not available, raw data follow

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

2005-01-13 Thread Uwe C. Schroeder
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Thursday 13 January 2005 01:44 pm, Bruce Momjian wrote: > Uwe C. Schroeder wrote: > [ PGP not available, raw data follows ] > > > -BEGIN PGP SIGNED MESSAGE- > > Hash: SHA1 > > > > On Thursday 13 January 2005 10:52 am, Goulet, Dick wrote: > >

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

2005-01-13 Thread Bruce Momjian
Uwe C. Schroeder wrote: [ PGP not available, raw data follows ] > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On Thursday 13 January 2005 10:52 am, Goulet, Dick wrote: > > Doug, > > > > OK, Assume that the binaries are installed under root, but a > > hacker cracks PostGres, what is to

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

2005-01-13 Thread Goulet, Dick
your saving grace or doom. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- From: Uwe C. Schroeder [mailto:[EMAIL PROTECTED] Sent: Thursday, January 13, 2005 4:14 PM To: PostgreSQL Admin Subject: Re: [ADMIN] Installing PostgreSQL as "postgress" versus &qu

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

2005-01-13 Thread Scott Marlowe
On Thu, 2005-01-13 at 15:13, Uwe C. Schroeder wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On Thursday 13 January 2005 10:52 am, Goulet, Dick wrote: > > Doug, > > > > OK, Assume that the binaries are installed under root, but a > > hacker cracks PostGres, what is to stop him/he

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

2005-01-13 Thread Uwe C. Schroeder
bout the data anyways. > > > Dick Goulet > Senior Oracle DBA > Oracle Certified 8i DBA > -Original Message- > From: Doug Quale [mailto:[EMAIL PROTECTED] > Sent: Thursday, January 13, 2005 11:56 AM > To: PostgreSQL Admin > Subject: Re: [ADMIN] Installing PostgreSQL

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

2005-01-13 Thread Doug Quale
"Goulet, Dick" <[EMAIL PROTECTED]> writes: > OK, Assume that the binaries are installed under root, but a > hacker cracks PostGres, what is to stop him/her from trashing all of the > database files in the first place? Their not owned by root. Installing > malware, whether it's actual code

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

2005-01-13 Thread Peter Eisentraut
Goulet, Dick wrote: > And in my book the executables are > of zero value whereas the data files, and their contained data, are > of infinite value. So under your scheme we're protecting the least > valuable part of the system at the expense of the most valuable. No, there is no expense in that se

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

2005-01-13 Thread Bruno Wolff III
On Thu, Jan 13, 2005 at 13:52:41 -0500, "Goulet, Dick" <[EMAIL PROTECTED]> wrote: > Doug, > > OK, Assume that the binaries are installed under root, but a > hacker cracks PostGres, what is to stop him/her from trashing all of the > database files in the first place? Their not owned by roo

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

2005-01-13 Thread Joshua D. Drake
ied 8i DBA -Original Message- From: Doug Quale [mailto:[EMAIL PROTECTED] Sent: Thursday, January 13, 2005 11:56 AM To: PostgreSQL Admin Subject: Re: [ADMIN] Installing PostgreSQL as "postgress" versus "root" Debate! "Goulet, Dick" <[EMAIL PROTECTED]> write

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

2005-01-13 Thread Goulet, Dick
nse of the most valuable. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- From: Doug Quale [mailto:[EMAIL PROTECTED] Sent: Thursday, January 13, 2005 11:56 AM To: PostgreSQL Admin Subject: Re: [ADMIN] Installing PostgreSQL as "postgress" versus &qu

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

2005-01-13 Thread Christopher Browne
Martha Stewart called it a Good Thing when [EMAIL PROTECTED] ("Goulet, Dick") wrote: > Well, thanks for the leeway, but getting one's nose rubbed in things for > good and bad comes with the turf. If there's one thing I've learned > about software over the years it's that there are many ways to sk

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

2005-01-13 Thread Christopher Browne
In an attempt to throw the authorities off his trail, [EMAIL PROTECTED] ("Tomeh, Husam") transmitted: > I've seen book that prefer installing PostgreSQL as root and another one > recommends otherwise by first creating a postgres account and then > installing it as postgres. In the Oracle world, yo

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

2005-01-13 Thread Christopher Browne
Martha Stewart called it a Good Thing when [EMAIL PROTECTED] ("Goulet, Dick") wrote: > You may well be on the development team, but you are wrong for > one very important reason. If the Postgresql executables are owned by > root they execute with the priviledges of root. Methinks you may

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

2005-01-13 Thread Bruno Wolff III
On Thu, Jan 13, 2005 at 08:06:05 -0800, "Tomeh, Husam" <[EMAIL PROTECTED]> wrote: > So does that mean there's no security issue using the root account to > install postrgeSQL as the first book indicated? Thanks. This depends on who you trust. The install scripts could potentially do bad things.

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

2005-01-13 Thread Matt Clark
Put all your eggs in one basket, and WATCH THAT BASKET. Better yet, pay someone more reliable than oneself to watch it. Preferably a well-paid and happy fox. Or _maybe_ put your eggs in an invisible super-basket? Not trolling, just checking the analogy integrity field. M --

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

2005-01-13 Thread Scott Marlowe
On Thu, 2005-01-13 at 06:41, Dawid Kuroczko wrote: > On Thu, 13 Jan 2005 12:20:41 +, Dick Davies > <[EMAIL PROTECTED]> wrote: > > > But only if either setuid root or executed by root. Hey, on my > > > system even /bin/sh is owned by root; it would be funny of it > > > executed as root > > C'mo

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

2005-01-13 Thread Dick Davies
* Dawid Kuroczko <[EMAIL PROTECTED]> [0151 12:51]: > On Thu, 13 Jan 2005 12:20:41 +, Dick Davies > <[EMAIL PROTECTED]> wrote: > > > But only if either setuid root or executed by root. Hey, on my > > > system even /bin/sh is owned by root; it would be funny of it > > > executed as root > > C'mo

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

2005-01-13 Thread Doug Quale
"Goulet, Dick" <[EMAIL PROTECTED]> writes: > to Postgres install as well. I as the DBA should be able to install, > upgrade, etc the software without access to the root account. Simply > put the fewer people who know the root password the fewer who can > destroy the system and the fewer who have

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

2005-01-13 Thread Tomeh, Husam
Peter Eisentraut; Tomeh, Husam; PgSQL ADMIN Subject: Re: [ADMIN] Installing PostgreSQL as "postgress" versus "root" Debate! Goulet, Dick wrote: >Whatever, I'll keep root only for absolutely restricted use & install >under a separate user account. Works just f

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

2005-01-13 Thread Joshua D. Drake
Those who dismiss this advice as my own imagination may want to check how other server packages are installed on their system. What user does sshd run under? Who owns /usr/sbin/sshd? What user does the MTA run under? Who owns the binaries? What user does Apache run under? Who owns the binarie

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

2005-01-13 Thread Goulet, Dick
k Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- From: Dick Davies [mailto:[EMAIL PROTECTED] Sent: Thursday, January 13, 2005 7:21 AM To: PostgreSQL Admin Subject: Re: [ADMIN] Installing PostgreSQL as "postgress" versus "root" Debate! * Dawid Kuroczko

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

2005-01-13 Thread Dawid Kuroczko
On Thu, 13 Jan 2005 12:20:41 +, Dick Davies <[EMAIL PROTECTED]> wrote: > > But only if either setuid root or executed by root. Hey, on my > > system even /bin/sh is owned by root; it would be funny of it > > executed as root > C'mon folks, the guy obviously made a booboo - no need to rub his >

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

2005-01-13 Thread Dick Davies
* Dawid Kuroczko <[EMAIL PROTECTED]> [0117 12:17]: > On Wed, 12 Jan 2005 20:52:16 -0800, Joshua D. Drake > <[EMAIL PROTECTED]> wrote: > > >Whatever, I'll keep root only for absolutely restricted use & install > > >under a separate user account. Works just fine & it makes the auditors > > >& sysadm

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

2005-01-13 Thread Dawid Kuroczko
On Wed, 12 Jan 2005 20:52:16 -0800, Joshua D. Drake <[EMAIL PROTECTED]> wrote: > >Whatever, I'll keep root only for absolutely restricted use & install > >under a separate user account. Works just fine & it makes the auditors > >& sysadmin feel better. > I don't argue the point of using root. I ag

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

2005-01-13 Thread Gémes Géza
oulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- From: Peter Eisentraut [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 12, 2005 7:01 PM To: Tomeh, Husam Cc: PgSQL ADMIN Subject: Re: [ADMIN] Installing PostgreSQL as "postgress" versus "root" Debate!

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

2005-01-13 Thread Peter Eisentraut
I wrote: > The current recommendation, which is reflected in the installation > instructions, is to install the software as root and to use the > postgres user for the database files. The advice seen elsewhere in > this thread to use the postgres user also for the software files is > wrong. Those

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

2005-01-12 Thread Doug Quale
Christopher Petrilli <[EMAIL PROTECTED]> writes: > As a security professional, why would the root user need to be > involved in the ownership of PostgreSQL? I see no reason for this, > but perhaps I'm missing something important. A number of years ago some Unices experimented with installing sys

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

2005-01-12 Thread Joshua D. Drake
gSQL ADMIN Subject: Re: [ADMIN] Installing PostgreSQL as "postgress" versus "root" Debate! On Wed, 12 Jan 2005, Goulet, Dick wrote: You may well be on the development team, but you are wrong for one very important reason. If the Postgresql executables are owned by root they execu

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

2005-01-12 Thread postgres
On Wed, 12 Jan 2005, Goulet, Dick wrote: > Whatever, I'll keep root only for absolutely restricted use & install > under a separate user account. Works just fine & it makes the auditors > & sysadmin feel better. Unfortunately, I _know_ how auditors think, but I would hope that a sensible compan

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

2005-01-12 Thread Bruce Momjian
to:[EMAIL PROTECTED] > Sent: Wednesday, January 12, 2005 7:01 PM > To: Tomeh, Husam > Cc: PgSQL ADMIN > Subject: Re: [ADMIN] Installing PostgreSQL as "postgress" versus "root" > Debate! > > Tomeh, Husam wrote: > > I've seen book that prefe

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

2005-01-12 Thread Goulet, Dick
:[EMAIL PROTECTED] Sent: Wednesday, January 12, 2005 11:14 PM To: Goulet, Dick Cc: Peter Eisentraut; Tomeh, Husam; PgSQL ADMIN Subject: Re: [ADMIN] Installing PostgreSQL as "postgress" versus "root" Debate! On Wed, 12 Jan 2005, Goulet, Dick wrote: > You may well be on the

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

2005-01-12 Thread Stephan Szabo
On Wed, 12 Jan 2005, Goulet, Dick wrote: > You may well be on the development team, but you are wrong for > one very important reason. If the Postgresql executables are owned by > root they execute with the priviledges of root. Thereby any local Not on any reasonable system unless instal

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

2005-01-12 Thread Joshua D. Drake
---Original Message- From: Peter Eisentraut [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 12, 2005 7:01 PM To: Tomeh, Husam Cc: PgSQL ADMIN Subject: Re: [ADMIN] Installing PostgreSQL as "postgress" versus "root" Debate! Tomeh, Husam wrote: I've seen book that pref

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

2005-01-12 Thread Goulet, Dick
r Oracle DBA Oracle Certified 8i DBA -Original Message- From: Peter Eisentraut [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 12, 2005 7:01 PM To: Tomeh, Husam Cc: PgSQL ADMIN Subject: Re: [ADMIN] Installing PostgreSQL as "postgress" versus "root" Debate! Tomeh, Hu

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

2005-01-12 Thread Tom Lane
Christopher Petrilli <[EMAIL PROTECTED]> writes: > On Thu, 13 Jan 2005 01:00:31 +0100, Peter Eisentraut <[EMAIL PROTECTED]> > wrote: >> The current recommendation, which is reflected in the installation >> instructions, is to install the software as root and to use the >> postgres user for the dat

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

2005-01-12 Thread Joshua D. Drake
Darcy Buskermolen wrote: On January 12, 2005 04:31 pm, Joshua D. Drake wrote: Peter Eisentraut wrote: Tomeh, Husam wrote: I've seen book that prefer installing PostgreSQL as root and another one recommends otherwise by first creating a postgres account and then installing it as postg

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

2005-01-12 Thread Joshua D. Drake
The current recommendation, which is reflected in the installation instructions, is to install the software as root and to use the postgres user for the database files. The advice seen elsewhere in this thread to use the postgres user also for the software files is wrong. As a security profe

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

2005-01-12 Thread Darcy Buskermolen
On January 12, 2005 04:31 pm, Joshua D. Drake wrote: > Peter Eisentraut wrote: > > Tomeh, Husam wrote: > >>I've seen book that prefer installing PostgreSQL as root and another > >>one recommends otherwise by first creating a postgres account and > >>then installing it as postgres. In the Oracle wor

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

2005-01-12 Thread Joshua D. Drake
Peter Eisentraut wrote: Tomeh, Husam wrote: I've seen book that prefer installing PostgreSQL as root and another one recommends otherwise by first creating a postgres account and then installing it as postgres. In the Oracle world, you don't use root to install the software. What is the best practi

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

2005-01-12 Thread Christopher Petrilli
On Thu, 13 Jan 2005 01:00:31 +0100, Peter Eisentraut <[EMAIL PROTECTED]> wrote: > Tomeh, Husam wrote: > > I've seen book that prefer installing PostgreSQL as root and another > > one recommends otherwise by first creating a postgres account and > > then installing it as postgres. In the Oracle worl

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

2005-01-12 Thread Peter Eisentraut
Tomeh, Husam wrote: > I've seen book that prefer installing PostgreSQL as root and another > one recommends otherwise by first creating a postgres account and > then installing it as postgres. In the Oracle world, you don't use > root to install the software. What is the best practice as far as > P

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

2005-01-12 Thread Christopher Petrilli
On Wed, 12 Jan 2005 15:30:06 -0800, Tomeh, Husam <[EMAIL PROTECTED]> wrote: > I've seen book that prefer installing PostgreSQL as root and another one > recommends otherwise by first creating a postgres account and then > installing it as postgres. In the Oracle world, you don't use root to > insta

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

2005-01-12 Thread Joshua D. Drake
Tomeh, Husam wrote: I've seen book that prefer installing PostgreSQL as root and another one recommends otherwise by first creating a postgres account and then installing it as postgres. In the Oracle world, you don't use root to install the software. What is the best practice as far as PostgreS

Re: [ADMIN] Installing postgresql-8.0.0beta3

2004-10-02 Thread Michael Long
Don´t forget to remove your old bison BEFORE "gmake install": type 'rpm -q -a|grep bison' you´ll get the installed bison package, type 'rpm -e ' to remove it You need the readline-devel-package, because you need the headers for readline. If you ever get such an error like the one with readline

Re: [ADMIN] Installing postgresql-8.0.0beta3

2004-10-02 Thread Tom Lane
Michael Long <[EMAIL PROTECTED]> writes: > I should have also included that when I do a "locate readline" I get the > following list. > ... > /lib/libreadline.so.4.3 Well, you've evidently got the library, but I don't see /usr/include/readline/readline.h, which makes me think you didn't install t

Re: [ADMIN] Installing PostgreSQL on Fedora from RPM

2004-05-17 Thread Lamar Owen
On Thursday 13 May 2004 09:36, Raul Secan wrote: > I just want to install the latest PostgeSQL database server (7.4.2). I am > running a Red Hat Fedora Core 1 OS, and I just found a link > (ftp://ftp10.us.postgresql.org/pub/postgresql/binary/v7.4.2/fedora/fedora-c >ore-1/) where I can download the