Re: Postgresql HOWTO?

[Petr Janda <elekktretterr@xxxxxxxxxxxxxx>]

Hi,
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.

Petr

Adrian M. Nida wrote:
> All,
>
> Today I got some time to actually work on some DF related things at home.  I 
> wanted to install Gallery [0] 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 [1] 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 [2] 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.
>
> Thanks,
>
> Adrian
>
> [0] http://gallery.sourceforge.net/
> [1] http://www.postgresql.org/
> [2] http://www.google.com/
>
> -------------------------------------------------
> This mail sent through IMP: http://horde.org/imp/
>
>
>
>