ster when the system boots.
For that, you do need to be root, since the startup scripts only have
permissions for root access, unless you want to compromise the security of
your system. However, you DO want the postmaster to be started by user
postgres within the startu
On Sun, 17 May 1998, Andy Lewis wrote:
> I'm not totall sure but, I wouldn't think that user postgres has enough system
> rights to install.
You should be root when doing the actual software installation to
/usr/local, but everything else should be done as the postgres user.
ally, I had to become root also to create the install
directories under /usr/local, and then change their ownership to my
postgres user, since that user doesn't have the rights to create
directories under /usr/local.
Brett W. McCoy
http://www.
On Sun, 17 May 1998, Peter Mount wrote:
> > However, you DO want the postmaster to be started by user postgres
> > within the startup scripts.
>
> Postgres will not run as root - it kills itself on purpose if you try.
I think that's ver
you should be able to connect,
otherwise it will refuse the connection.
Brett W. McCoy
http://www.lan2wan.com/~bmccoy/
---
"The number of UNIX installations has grown to 10,
: read the PostgreSQL Administrator's Guide. It describes
it more detail how to set up users and access to different databases.
Brett W. McCoy
http://www.lan2wan.com/~bmccoy/
--
On Fri, 15 Dec 2000, Niral Trivedi wrote:
> I have very simple two questions..
>
> How can we 'describe a table' and 'view all available tables' in postgres
> DB??
>
> I am looking for something similar to 'desc ' and 'show tables' in
> MySQL or
> 'desc ' and 'select * from tab' in Oracle..
If y
On Sun, 24 Dec 2000, Thomas SMETS wrote:
> I'm runnin postgres 7.?? (Last RPM package available from the site).
>
> I want to create a few DB creation scripts so I can "publish" that
> afterwards.
> On Oracle there's a such possibility but I haven't seen anything
> comaprable in the docs ...
> I
On Fri, 19 Oct 2001, James Kelty wrote:
> I have a table with a column that needs renameing. I do not know how to do
> this, and if anyone could point me in the right direction, I would really
> appreciate it!
ALTER TABLE RENAME TO ;
This is documented in the PostgreSQL reference manual:
htt
On Wed, 17 Oct 2001, Francisco Solari wrote:
> I'm running postgresql 6.5.3 on RedHat 6.2 and when I try to run
> vacuum from psql I receive the following message:
> PortalHeapMemoryFree: 0x82ca450 not in alloc set!.
> Also when I use the \dt command i receive the "Could'n find any tables!"
On Fri, 12 Oct 2001, postgresql wrote:
> Could someone create a post that shows who(user) should own
> what. I have always let postgres own the pgsql directory and I see
> that it is recomended that root own it.
Whenver I have installed postgres (as the postgres user), it has always
installed ev
On Fri, 12 Oct 2001, Stefan Huber wrote:
> Well, this might be true, if you are on a system, where more than one
> humans are operating. Or are there some other reasons behind this philosophy?
> I mean, a buffer overflow (I don't claim to know of any in Postgres) can
> cause more problems when ru
On Thu, 29 Nov 2001, Jodi Kanter wrote:
> I need to create a diagram of our schema. I recently obtained a copy
> of Visio. Has anyone used Visio to reverse engineer a model diagram
> from a Postgres database?? If not, can anyone recommend the best way
> to create a schema from Postgres without
On Fri, 25 Jan 2002, Bolt Thrower wrote:
> In the query:
>
> select field, length(field) from table where length(field) < 10;
>
> How many times is the length() function called for each row? Once or
> twice?
I would expect it to run both times.
I did a similar query with an explain:
ex
On Thu, 14 Feb 2002, Linda Fousek wrote:
> I am installing postgresql on a win2000 machine. I have installed cygwin and
> cygipc, and I'm getting the following error when trying to run ./configure
>
> loading cache ./config.cache
> checking host system type ... i686-pc-cygwin
> checking which tem
On Fri, 1 Mar 2002, Gary Stainburn wrote:
> Does anyone else get this message when they post to the list or is it just me?
>
> Firstly, the emails I'm sending don't have attachments!!!
> Secondly, if they did have a .bat extension, my virus s/w wouldn't let it out
> of the building
> Thirdly, my
On Fri, 1 Mar 2002, Dan Langille wrote:
> On 1 Mar 2002 at 11:15, Brett W. McCoy wrote:
>
> > I'm guessing it's coming from the server that hosts [EMAIL PROTECTED] --
> > you're stuff isn't coming with any attachments on my system (also Linux).
>
17 matches
Mail list logo