the other side of the firewall

August 25, 2005

installing postgres on Solaris 10

I had some minor trouble installing postgres on Solaris 10.
For instance, I had the following error message:

ld.so.1: initdb: fatal: libreadline.so.5: open failed:
No such file or directory
Killed

So, here is a summary of what I had to do.

  • install the libreadline package (can be found on the Sun web site)
    pkgadd -d SFWrline
  • install the postgres package (postgresql-8.0.1-sol10-sparc-local) from sunfreeware
    pkgadd -d postgresql-8.0.1-sol10-sparc-local
  • add a symbolic link for libreadline.so.5
    ln -s libreadline.so libreadline.so.5
  • make sure your LD_LIBRARY_PATH is properly set-up
    export LD_LIBRARY_PATH=/usr/local/pgsql/lib:/opt/sfw/lib

  • run the init command
    /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
  • et voilà

    Success. You can now start the database server using:
    /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data
    or
    /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data -l logfile start

MySQL and Postgres front-ends

Filed under: Development, Databases

When doing some development and administration with MySQL or Postgres, the command line is not always the most convenient way to do.
Here are some tools that can be front-ends to the database.

For MySQL:

For PostgresQL:

  • pgAdmin III (this is part of the Postgtres distribution on Windows) (free)





















Get free blog up and running in minutes with Blogsome | Theme designs available here