PostgreSQL on system with root as only user

No, you can't.
You need postgres user for sure.
Postgresql database doesn't run on root account.

~Harpreet

I am about to install PostgreSQL on a minimal Linux system, where root
is the only user that is allowed to exist. I would prefer to use a
binary installer. Is it possible to install PostgreSQL without the
postgres user?

PostgreSQL refuses to start up as root user for security
reasons (this is a feature).

If you know what you're doing and you want to disable that
feature you need to recompile from source and disable the
uid checks in src/backend/main/main.c.

Unless you're working in the embedded space or some such thing,
I don't think it's a good idea, anyway.

Bye :)
Chris.

--

Chris Mair
http://www.1006.org

"Fredrik Israelsson" <fredrik.israelsson@eu.biotage.com> writes:

I am about to install PostgreSQL on a minimal Linux system, where root
is the only user that is allowed to exist.

You've *got* to be kidding. That's possibly the stupidest system design
decision I've ever heard ... what is the point of disallowing non-root
userids? It certainly can't improve system security to run everything
as root.

regards, tom lane

Well, no actual "design decision" is made yet. Just testing...

...actually, in embedded, minimalistic environments, I don't think it's
unusual to have one and only one user.

/Fredrik

-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: den 30 augusti 2006 15:17
To: Fredrik Israelsson
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] PostgreSQL on system with root as only user

"Fredrik Israelsson" <fredrik.israelsson@eu.biotage.com> writes:

I am about to install PostgreSQL on a minimal Linux system, where root

is the only user that is allowed to exist.

You've *got* to be kidding. That's possibly the stupidest system design
decision I've ever heard ... what is the point of disallowing non-root
userids? It certainly can't improve system security to run everything
as root.

regards, tom lane

On Wed, 2006-08-30 at 09:17 -0400, Tom Lane wrote:

"Fredrik Israelsson" <fredrik.israelsson@eu.biotage.com> writes:

I am about to install PostgreSQL on a minimal Linux system, where root
is the only user that is allowed to exist.

You've *got* to be kidding. That's possibly the stupidest system design
decision I've ever heard ... what is the point of disallowing non-root
userids? It certainly can't improve system security to run everything
as root.

Remember the glory of heaven and earth before man was created?

;-)

On Wed, Aug 30, 2006 at 03:34:22PM +0200, Fredrik Israelsson wrote:

Well, no actual "design decision" is made yet. Just testing...

...actually, in embedded, minimalistic environments, I don't think it's
unusual to have one and only one user.

Yeah, but in embedded minimalisatic POSIX-compatable environment, I
imagine multiple users are somewhat of a requirement. It's not like a
UID costs anything, it's just a number...

Have a nice day,
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/

On Aug 30, 2006, at 9:01 , Chris Mair wrote:

If you know what you're doing and you want to disable that
feature you need to recompile from source and disable the
uid checks in src/backend/main/main.c.

Unless you're working in the embedded space or some such thing,
I don't think it's a good idea, anyway.

Has anyone actually used PostgreSQL on an embedded system? I am
genuinely curious. How about db performance from a flash drive?

-M

Unless it's a read-only database, I would never recommend using flash
media for an RDBMS.

Unless it's a small database, I would never recommend using USB as a
storage interface for an RDBMS.

--
Brandon Aiken
CS/IT Systems Engineer
-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of AgentM
Sent: Wednesday, August 30, 2006 10:42 AM
To: PostgreSQL General ML
Subject: Re: [GENERAL] PostgreSQL on system with root as only user

On Aug 30, 2006, at 9:01 , Chris Mair wrote:

If you know what you're doing and you want to disable that
feature you need to recompile from source and disable the
uid checks in src/backend/main/main.c.

Unless you're working in the embedded space or some such thing,
I don't think it's a good idea, anyway.

Has anyone actually used PostgreSQL on an embedded system? I am
genuinely curious. How about db performance from a flash drive?

-M

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

On Aug 30, 2006, at 12:03 , Brandon Aiken wrote:

Unless it's a read-only database, I would never recommend using flash
media for an RDBMS.

Well, it's an embedded device, so you can pretty much be certain that
it's not storing sales information. If the flash goes belly up, then
the device has failed anyway, so the lost info is the least of the
problems.

Unless it's a small database, I would never recommend using USB as a
storage interface for an RDBMS.

Why? Could you provide more details?

I would be interested in any performance numbers anyone has collected.

-M

I haven't got any numbers (or a USB stick I can test with at the moment)
but USB is going to be a bottleneck for read and write performance.
Unless you're accessing very small amounts of data or running small
queries, I would expect performance to be pretty poor.

If your data set is so small, why do you need a full RDBMS instead of
flat data/text files or SQLite? If you're not concerned about disk
media failure, why do you need a transactional DB? It seems like
putting a deadbolt on a screen door.

It might work just great for your device, of course, but I would not
expect it to scale well at all.

--
Brandon Aiken
CS/IT Systems Engineer

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of AgentM
Sent: Wednesday, August 30, 2006 1:21 PM
To: PostgreSQL General ML
Subject: Re: [GENERAL] PostgreSQL on system with root as only user

On Aug 30, 2006, at 12:03 , Brandon Aiken wrote:

Unless it's a read-only database, I would never recommend using flash
media for an RDBMS.

Well, it's an embedded device, so you can pretty much be certain that
it's not storing sales information. If the flash goes belly up, then
the device has failed anyway, so the lost info is the least of the
problems.

Unless it's a small database, I would never recommend using USB as a
storage interface for an RDBMS.

Why? Could you provide more details?

I would be interested in any performance numbers anyone has collected.

-M

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

On Aug 30, 2006, at 13:58 , Brandon Aiken wrote:

I haven't got any numbers (or a USB stick I can test with at the
moment)
but USB is going to be a bottleneck for read and write performance.
Unless you're accessing very small amounts of data or running small
queries, I would expect performance to be pretty poor.

Indeed, that's pretty much our scenario- a rack-mounted Linux box
storing mostly inconsequential data (auth creds) with a flash drive-
quasi-embedded, I guess.

If your data set is so small, why do you need a full RDBMS instead of
flat data/text files or SQLite? If you're not concerned about disk
media failure, why do you need a transactional DB? It seems like
putting a deadbolt on a screen door.

MySQL and SQLite have terrible concurrent performance with
transactions. We would also like to take advantage of database-level
replication instead of our fragile home-grown thing for load-sharing
and failover.

It might work just great for your device, of course, but I would not
expect it to scale well at all.

There are some things I can do- for example, fsync should probably
just be off. I guess I should simply go ahead and try it. Thanks for
the discussion!

-M