DragonFly users List (threaded) for 2006-09
Re: Postgresql HOWTO?
1) Uninstall all postgres packages from your machine
You can do step number 2 in 2 ways:
2a) echo 'PKG_RCD_SCRIPTS=yes' >> /etc/mk.conf
or this way
2b) ln -s /usr/pkg/etc/rc.d/pgsql /etc/rc.d/
The 'a' way is better imo.
2) Install databases/postgres_81
3) echo 'pgsql=YES' >> /etc/rc.conf
4) Start up pgsql: /etc/rc.d/pgsql start
5) Add pgsql superuser: su - pgsql
6) "createuser root" and follow instructions till it returns you back to
command line, make sure you make a superuser account. The instructions
will ask you what type of account you want to create.
7) type exit and enter, which takes you back to your root account.
8) createdb testdb;
9) cd /usr/pkg/pgsql/data
10) Open pg_hba.conf and play with permissions, learn how to set
permissions in pgsql.
After you create the super user you can add any other accounts with the
createuser command with your regular root account and you DONT need to
su - pgsql anymore.
Adrian M. Nida wrote:
Today I got some time to actually work on some DF related things at home. I
wanted to install Gallery  so I could share some pics to family members (the
other reason was that my DF box ran Gallery back in the pre-1.2 days).
Happily, I found Gallery isn't in pkgsrc. The source install consists of a
bunch of php files, so I was fine with that.
During the installation process, Gallery asks for a database connection.
Thinking I had PostgreSQL  installed, I tried to run it against that. To my
surprise I discovered that this box only had the client, not the server,
installed. I completed a source install of /usr/pkgsrc/postgresql80-server and
tried to run it.
At this point, I discovered that pkgsrc does not install *any* PostgreSQL
startup files. I have a bunch of sample config files in /usr/pkg/share/
postgresql, but nothing that looks like a startup. I'm also assuming that the
config files are supposed to go in /usr/pkg/etc/postgresql.
My question is whether anyone out there has a PostgreSQL (8.0) HOWTO? I tried
the combinations "pkgsrc postgresql howto" and "netbsd postgresql howto" on
Google  but neither returned anything remotely useful. Heck, at this point
I'd appreciate just some general pointers/clarifications.
As many of you know, I'm quite content writing a HOWTO (and slaving through the
labor of what works and what doesn't) from scratch. I'm just trying to figure
out far "scratch" actually is.
This mail sent through IMP: http://horde.org/imp/