PostgreSQL

Aus immerda

Postgresql ist ein robuster Datenbank Server

Inhaltsverzeichnis 1 installation 1.1 gentoo 1.2 ubuntu / debian 1.3 centos 2 Configuration 2.1 ssl 3 Security 4 useful commands

installation

gentoo

• http://www.gentoo.org/doc/en/postgres-howto.xml

ubuntu / debian

• http://www.cyberciti.biz/faq/linux-installing-postgresql-database-server/

centos

• http://www.cyberciti.biz/faq/howto-fedora-linux-install-postgresql-server/

Configuration

• http://gentoo-wiki.com/HOWTO_Configure_Postgresql
• http://www.cyberciti.biz/faq/howto-add-postgresql-user-account/

ssl

• http://www.postgresql.org/docs/8.2/static/ssl-tcp.html

Security

• http://security.immerda.ch/?p=8

useful commands

select * from pg_user;
select * from pg_group;
select datname from pg_database;
select tablename from pg_tables;

\dt # database tables
\dt *.*