Key points for installing PostgreSQL 8.04 in Ubuntu 8.3

My system is Ubuntu 8.04 on a virtual machine.

1. Go to http://www.postgresql.org where the next postgreSQL core 8.3.

2. Run the tar-xvf postgreSQL-8.3.3.tar.bz2 to decompress

3. Go to the decompressed folder and run the./configure command to automatically check the system configuration.

4. Unfortunately, a message "c cannot output the executable file" is reported"

Read more: Install PostgreSQL8.3 in Ubuntu [multi-figure]

5. Then I found the information on the Internet and found that the libc was not upgraded, so use the command: sudo apt-get install libc6-dev gcc g ++

6. Run "./configure" again, but the readline library is not found is reported. If this error can be solved, zlib is not found may be reported.

7. Unfortunately I found more than 2 hours, downloaded countless related packages, and finally ended in readline5-dev package cannot be installed properly.

8. There is no way to run./configure -- without-readline -- without-zlib.

9. Then make

10. The following command adds sudo

Make install
Adduser postgres
Mkdir/usr/local/pgsql/data
Chown postgres/usr/local/pgsql/data

Here, we need to create a logfile and copy it to/usr/local/pgsql/data/(it seems that you can do it without copying it. You can try it)

Then switch the user sudo-ipvs

/Usr/local/pgsql/bin/initdb-D/usr/local/pgsql/data
/Usr/local/pgsql/bin/postgres-D/usr/local/pgsql/data> logfile 2> & 1 &
/Usr/local/pgsql/bin/createdb test
/Usr/local/pgsql/bin/psql test

Finally, you can see the SQL interactive interface.