In order to use a version that is as much compatible as possible with Amazon Redshift you need version v8.0.2.
You can build it in few minutes.
Install requirements
sudo apt-get install make gcc libreadline-dev zlib1g-dev -y
Choose the directory where you want to install it, I recommend using
export PGROOT=/usr/local/
Then download it and build it with the following commands
cd /tmp
wget https://ftp.postgresql.org/pub/source/v8.0.2/postgresql-8.0.2.tar.gz
tar xf postgresql-8.0.2.tar.gz
cd postgresql-8.0.2
./configure --prefix=$PGROOT
make
sudo make install
Environment
Do not forget to add $PGROOT/bin to your $PATH: it should be already
ok if you used the PGROOT recommended above.
Consider set your environment to point to your main database. For example I added to my ~/.bashrc something like
Redshift hostname. You can find it in the AWS console, look for Cluster Endpoint in your Redshift instance Configuration tab: it is something like my-dw-instance.nctgnxb2tav5.us-east-1.redshift.amazonaws.comPGPORT
5439, is default Redshift password.
PGDATABASE
Your database name.
PGUSER
Your database user name.
Do not use PGPASSWORD to set credentials, it is strongly recommended to use a pgpass file (read below).
Credentials
It is a good choice to use a pgpass file to store passwords.