Rép. : Re: start/stop a database
От | Erwan DUROSELLE |
---|---|
Тема | Rép. : Re: start/stop a database |
Дата | |
Msg-id | 442fac0b6acff0d9d3983e160f6a764b3ffee40b@ обсуждение исходный текст |
Ответы |
Re: Rép. : Re: start/stop a database
|
Список | pgsql-general |
Scott, Though there is not exact match, you may consider that: Oracle instance <=> Postgres cluster Oracle schema <=> Postgres database. But there is a schema concept in Postgres that is pretty similar to the one in Oracle. ( Actually, I think there is a lack of "database" concept in Oracle.) That's why you cannot "start" or "stop" a db. You start or stop a cluster. But you can deny acess to a database with pg_hba.conf as tatyana.krasnokutsky explained. Other gotchas for those who come from the Oracle world: - PostgreSQL = pg = postgres - autocommit is the default in pg. If you want to be able to rollback, you must issue a BEGIN first. - no Toad on pg ;-), though there are several graphical admin tools. I like Pgadmin III: http://www.pgadmin.org/pgadmin3/index.php - don't forget to VACUUM your db VERY often. Usually: more than once a day on active databases. Carefully read the docson that subject. - no tablespace, no storage clause, no initial, next, .... Tablespaces should come up soon however (pg 7.5?) - no archive log, a.k.a. Point in Time Recovery. So there are only full backups. - the equivalent of initSID.ora is postgresql.conf - in postgresql.conf, always set fsync=TRUE unless you are ready to loose your db afret a power failure. - in postgresql.conf, shared_buffers is the equivalent db_block_buffers in initSID.ora. Don't set it to high, it is notusefull. Let the file system cache the data. - COPY is (roughly) the equivalent of SQL*LOAD HTH, Erwan >>> "scott.marlowe" <scott.marlowe@ihs.com> 09/01/2004 15:46:16 >>> On Mon, 5 Jan 2004 tatyana.krasnokutsky@gsa.gov wrote: > Hello, > I am new in PostgreSQL world coming from Oracle. > I have created two databases using command line as manual has suggested. > For instance I have done like the following: > createdb tanya > createdb eps > Now I would like to stop my "tanya" database and have "eps" database > running. > How can I do this?
В списке pgsql-general по дате отправления: