HostedDB - Dedicated UNIX Servers

Securing-Optimizing-RH-Linux-1_2_338
Comments and suggestions concerning this book should be mailed to gmourani@videotron.ca © Copyright 1999-2000 Gerhard Mourani and Open Network Architecture ® 338 template1e create database foo; CREATEDB NOTE: Client connections can be restricted by IP address and/or user name via the pg_hba.conf” file in PG_DATA. Other useful Postgres terminal monitor program (psql) are: · To connect to the new database, use the command: template1e \c foo connecting to new database: foo fooe · To create a table, use the command: fooe create table bar (i int4, c char(16)); CREATE fooe · To inspect the new table, use the command: fooe \d bar Table    = bar +----------------------------------+----------------------------------+------------+ |              Field |              Type | Length  | +----------------------------------+----------------------------------+------------+ | I | int4 |           4 | | c | char() |         16 | +----------------------------------+----------------------------------+------------+ fooe · To drop a table, index, view, use the command: fooe drop table table_name; fooe drop index index_name; fooe drop view view_name; · To insert into: (once a table is created, it can be filled using the command…) fooe insert into table_name (name_of_attr1, name_of_attr2, name_of_attr3) fooe values (value1, value2, value3); Installed files > /etc/rc.d/init.d/postgresql > /etc/rc.d/rc0.d/K15postgresql > /etc/rc.d/rc1.d/K15postgresql > /etc/rc.d/rc2.d/K15postgresql > /etc/rc.d/rc3.d/S85postgresql > /etc/rc.d/rc4.d/S85postgresql > /etc/rc.d/rc5.d/S85postgresql > /etc/rc.d/rc6.d/K15postgresql > /usr/bin/postgres > /usr/bin/postmaster > /usr/bin/ecpg > /usr/bin/pg_id > /usr/bin/pg_version > /usr/bin/psql > /usr/bin/pg_dump > /usr/bin/pg_dumpall > /usr/bin/pg_upgrade > /usr/bin/pg_passwd > /usr/bin/cleardbdir > /usr/man/manl/begin.l > /usr/man/manl/close.l > /usr/man/manl/cluster.l > /usr/man/manl/commit.l > /usr/man/manl/copy.l > /usr/man/manl/create_aggregate.l > /usr/man/manl/create_database.l > /usr/man/manl/create_function.l > /usr/man/manl/create_index.l > /usr/man/manl/create_language.l > /usr/man/manl/create_operator.l > /usr/man/manl/create_rule.l > /usr/man/manl/create_sequence.l > /usr/man/manl/create_table.l > /usr/man/manl/create_trigger.l > /usr/man/manl/create_type.l > /usr/man/manl/create_user.l > /usr/man/manl/create_version.l > /usr/man/manl/create_view.l