Re: Doubts PostgreSQL
| От | Jorge Torralba |
|---|---|
| Тема | Re: Doubts PostgreSQL |
| Дата | |
| Msg-id | CACut7uS7T5eJLzSptdSA2tuo=7=gGjdYnuYF++F4DSUMTeP_2g@mail.gmail.com обсуждение исходный текст |
| Ответ на | Doubts PostgreSQL ("rafael.burischipfer" <RAFAEL.BURISCHIPFERUSA@GMAIL.COM>) |
| Список | pgsql-admin |
You need to remove the way oracle manages databases, roles and instance from your mind. It is different in postgres.
1. You can create a table space and then create a database in a specific table space. Look at postgres documentation for creating databases. If you're talking about archiving wal files, you specify that at postgresql.conf. The cluster will archive to where it is noted in the archive command. but this applies to the entire cluster and not per database.
2. Use symbolic links for pg_xlog if you want them somewhere else.
3. At compile time you can set the size with --with-wal-segsize=xxx. But I would manage this differently with configuration parameters.
4. You probably would want to split your different prod databases into separate instances so a failure of one does not impact another. Start postgres for your separate instances on separate ports and separate data dirs. for example
pg_ctl -D prod1/data -o "-p 5432" start
pg_ctl -D prod2/data -o "-p 5433" start
Obviously you would need to initialize and get the instances going first before doing above. You can then asign role passwords to each instance.
You could create three separate databases on a single cluster. But a user is global across all databases. Therefore you cannot have separate passwords for the same user on a single cluster.
JT
On Thu, Oct 8, 2015 at 7:35 AM, rafael.burischipfer <RAFAEL.BURISCHIPFERUSA@gmail.com> wrote:
Hello everybody,
I'm Oracle, DB2 and SQL Server DBA, and now I started work with PostgreSQL
and I have some doubts.
1) Can I archive different databases in different directory path?
Example:
I want archive the database production 1 in '/mnt/production_1/archive' and
production 2 in '/mnt/production_2/archive'
2) I want change the WAL location, I don't want the WAL files stay in
default location, I want for example in '/PGDATA/WAL', and Can I create
different WALs to different databases?
3) Can I improve the WAL size? the default is 16,384 KB, I want for example
51,200 KB it is possible?
4) In my instance I have three databases (Production 1, Production 2 and
Production 3), and I have a role named UserProd with password 'test123', I
want the Production 1 database the password be 'passwd123' in Production 2
database be '123-passwd' and in Production 3 database be 'test123', it is
possible?
Thanks a lot people
--
View this message in context: http://postgresql.nabble.com/Doubts-PostgreSQL-tp5869292.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Thanks,
Jorge Torralba
----------------------------
Note: This communication may contain privileged or other confidential information. If you are not the intended recipient, please do not print, copy, retransmit, disseminate or otherwise use the information. Please indicate to the sender that you have received this email in error and delete the copy you received. Thank You.
Jorge Torralba
----------------------------
Note: This communication may contain privileged or other confidential information. If you are not the intended recipient, please do not print, copy, retransmit, disseminate or otherwise use the information. Please indicate to the sender that you have received this email in error and delete the copy you received. Thank You.
В списке pgsql-admin по дате отправления: