• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 762
  • Last Modified:

PostgreSQL transaction log

In PostgreSQL, can we create table space for transaction log usage ? for example in sybase we  have space for data and log, how about postgreSQL ? one thing I notice, using pgadmin I can only assign one tablespace for db, can PostgreSQL have multiple tablespace ?
0
motioneye
Asked:
motioneye
1 Solution
 
earth man2Commented:
you can have multiple tablespaces.
see CREATE TABLESPACE and CREATE TABLE .... TABLESPACE ...
in SQL Reference in PostgreSQL documentation.

the transaction log does not need a separate tablespace.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now