OS File Size > 1GB - Mailing list pgsql-admin

From Chris Ruprecht
Subject OS File Size > 1GB
Date
Msg-id 200207251250.30219.chrup@earthlink.net
Whole thread Raw
Responses Re: OS File Size > 1GB  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Hi all,

The default size of a Postgres file seems to be 1 GB. I know, I can increase
that by modifying <can't remember what it was I did here - that parameter
which gives you the file size, once you divide it by the blocksize>
My question is: is it safe to do so?
My motivation: I symlink the files across different drives but when postgres
decided to create a new file (.1, .2, .3 ...) they are created in the
data/base/nnnn directory and not where all his little brothers and sisters
live and where they SHOULD be.

Best regards,
Chris

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Maximum Number of Tables in a database
Next
From: Mathieu Arnold
Date:
Subject: Re: CREATE TABLE AS ...