...
There are lots of details which are not specified here.
We'll lean on PG Experts to make recommendations as needed.
For example, for the file system we could ext3 or xfs.
I don't have an opinion on this, even after a lecture.
To help make decisions in these cases we prefer simplicity (see above) and consistency (see our other centos machines).
Memory
We have plenty of memory.
PG Experts shall recommend valuesSize of database plus about 500 MB
We chose 8 GB.
Disk Partitions
PG Experts shall recommend a size for each partition.
...
To see how much space a server is currently using:
psql# select datname, pg_size_pretty(pg_database_size(datname)) from pg_database;
I do not have any data growth information.
But we know that street addresses do not change much in the city.
We do have one area of the application that (ab)uses audit tables - but I would be a little surprised if this became an issue.
Session with Spencer and Jeff Frost
new vm
custom
provide name
select hypervisor
select data store
select vm version: 7
select OS: centos 4/5 64 bit
select number of processors: 2
specify RAM> 8GB
specify NIC: 1 NIC
scsi controller: LSI Logic parallel
create new virtual disk
- store with VM
- specify size (32 GB)
- specify thin provisioning
- advanced options (take defaults)
Edit VM setting before completion! - new CD/DVD
- datastore ISO file
- navigate to ISO
connect at power on
edit options - reserve memory: 8GB
right click on VM - power on
- install centos
- enter (to select grpahical installer)
- skip media test
- next
- english/english
- yes - erase all data
START partitioning - choose review and modify partitioning layout / Next
- yes to warning
- partitioning layout panel - choose reset
- new / 4096; force to be primary; ext3
- new; type swap; 4096 MB; not primary
- /data; ext3; 16384 MB
- /pg_xlog; ext3; 4096
- /var; 2048; ext3
- /home; 2048; ext3
END partitioning
Next
Next (install boot loader)
specify IP and netmask
specify gateway
specify DNS
uncheck gnome and all other (keep install small)
next
next
install will commence