Re: PostgreSQL dirver? - Mailing list pgsql-general

Yes, this is a little disconcerting.  Debian installs
PostgreSQL according the the Linux Filesystem
Hierarchy Standard, which means that instead of one
/usr/local/postgresql directory you get various files
scattered all over the place.  However, once you learn
a little bit more about the FHS you will see that it
mostly makes sense.  More importantly, you can easily
query the system to find out where it installed the
various files.  Try typing in 'dpkg -L postgresql'.

You can also do apt-cache search postgresql to see
what other packages have something to do with
postgresql.  I would especially recommend the
postgresql-doc package.

The documentation for any given package is generally
found in /usr/share/doc/package-name, and most
packages have a Debian specific README with some
useful hints.  The actual databases are stored in
/var/lib/postgres and the configuration files in
/etc/postgresql .

I personally find the Debian PostgreSQL packages to be
amazingly well done, and I have happily turned the
maintenance of this package over to Oliver :).  Make
sure you get the most recent packages, however.
Debian Stable still has PostgreSQL 6.5.3, and with 7.2
currently in beta you don't want to be developing with
6.5.3.

Jason

--- Mayan <escalante@canada.com> wrote:
> I have taken the task of installing and
> investigating PostgreSQL.
>
> Using Debian's 'apt-get', I have installed
> PostgreSQL, this had
> the advantage of a brainless and quick installation.
> I was able to
> create a database in literally seconds after
> creating my account.
> However, it has a drawback; I have no idea where the
> application
> was installed nor where any of the help files are,
> for that I have
> to do a more in depth research of the Debian's file
> system. But if
> anyone here can give some hints it will be very, and
> I mean VERY
> MUCH appreciated.
> For the time being though, I am installing
> "Qt-3.0.0". To do this
> I need to specify what sql driver I want to use to
> hook
> up future applications to the PostgreSQL database.
> So, my question
> is: what would be the driver, if any, that I have to
> specify in the
> './configure' '-qt-sql-<driver>' parameter?
>
> Thanks in advancer
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: you can get off all lists at once with the
> unregister command
>     (send "unregister YourEmailAddressHere" to
majordomo@postgresql.org)


__________________________________________________
Do You Yahoo!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com