06/28/2006: Postgresql; Connecting to PostgreSQL from a remote client.
I see many web pages that mention the pg_hba.conf file which control which hosts and user can connect to which database.
However, there is a listen_addresses parameter in postgresql.conf which needs to be set. By default, it was commented out so that no remote client connections could be made - certainly a reasonable security precaution.
In order to accept connections from remote client you need to set the listen_addresses parameter to something other than localhost. For example, if your PostgreSQL server sits on 192.168.1.123 then that could be the value for listen_addresses. If your PostgreSQL server has multiple addresses, you could use * so that remote clients can connect to any of the IP addresses. Or use a comma-delimited list if only some of the IP address should be used when connecting to PostgreSQL.
06/28/2006: Ubuntu Disk Partition Sizes
Various documentation that I read said that the root of Ubuntu needed less than 200Mb. However, I’ve found that not to be true.
In my situation, I ran out of disk space. So I’ve bumped the root partition to 500Mb. On my 80Gb drive, Here are my partition sizes:
medined@thog:~$ df Filesystem 1K-blocks Used Available Use% Mounted on /dev/hda1 481764 282766 173296 63% / /dev/hda8 51675672 923812 48126844 2% /data /dev/hda5 3099260 1593760 1348068 55% /usr /dev/hda7 10317828 556548 9237164 6% /usr/local /dev/hda6 10317828 337728 9455984 4% /var
I also have a 1,000Gb swap - mainly because when I tried to install Oracle it asked for a 750Mb swap file.
UPDATE: One mistake (there are probably others) that I made was that the /tmp path needs a lot of room because that is where installation place files. So two choices - either give the root partition another couple of gigabytes just for software installation. Or give /tmp its own 2Gb partition. Or, as I am doing, constantly tell each installation process to place temp files in a /data/tmp (or whatever) directory.