I wasn't trying to fight it. It's just that the port disagrees with the
PG documentation and apparently most other ports. The maintainer said
it was for backward compatibility but it's apparently only a FreeBSD
"phenomenom" :-)
It may be a *BSD pheonomenon, since I know it applies in NetBSD as
Vivek Khera wrote:
if you want to use the freebsd ports system (which is advisable) don't
fight against it. use the recommended/defaults where you can.
I wasn't trying to fight it. It's just that the port disagrees with the
PG documentation and apparently most other ports. The maintainer sa
On Jul 2, 2006, at 9:55 AM, Joe wrote:
I'm now migrating to FreeBSD and was surprised to find that the
port used 'pgsql' as the user. The maintainer said that was done
to ensure backward compatibility because that *was* the original
name. Since I didn't need to be backward compatible (an
Tom Lane wrote:
Plan B is to leave the pgsql user alone and add another superuser named
postgres. You can have more than one superuser ...
Yes, that's what my hosting provider (hub.org, which also hosts
postgresql.org) seems to have done. This also avoids another minor
problem: initdb on U
Joe <[EMAIL PROTECTED]> writes:
> It was when I tried starting PostgreSQL from boot, which requires adding
> "postgresql_enable" in /etc/rc.conf, that it didn't work. I tracked
> that down to /usr/local/etc/rc.d/010.pgsql.sh which uses a
> "postgresql_user" variable defined as "pgsql" by the po
Tom Lane wrote:
FreeBSD is out in left field here. However, I don't see why you need to
alter the build to change this. Just create a new user postgres and run
the initdb step as that user. initdb uses the OS user name it's run as
to determine the initial superuser name.
That's exactly what
Joe <[EMAIL PROTECTED]> writes:
> I'm now migrating to FreeBSD and was surprised to find that the port
> used 'pgsql' as the user. The maintainer said that was done to ensure
> backward compatibility because that *was* the original name.
It's always been "postgres", at least as far as the stand
On 7/2/06, Joe <[EMAIL PROTECTED]> wrote:
Hi,
I started using PostgreSQL (8.0) about a year ago on Windows. Following
the installation instructions, I created a 'postgres' user (BTW, this
was based on the Short Version instructions for UNIX, i.e., "adduser
postgres" --I'm not sure it this is ma
Hi,
I started using PostgreSQL (8.0) about a year ago on Windows. Following
the installation instructions, I created a 'postgres' user (BTW, this
was based on the Short Version instructions for UNIX, i.e., "adduser
postgres" --I'm not sure it this is made explicit elsewhere, even for UNIX).
