Re: Can't take base back up with Postgres 9.0 on Solaris 10

On Thursday 28 October 2010 5:07:06 am dan.m.harris wrote:
> Hi Thom, thanks for your reply. Here's my psql output:
>
> bash-3.00$ bin/psql
> psql (9.0.1, server 8.1.4)
> WARNING: psql version 9.0, server version 8.1.
> Some psql features might not work.
> Type "help" for help.
>
> postgres=# SHOW wal_level;
> ERROR: unrecognized configuration parameter "wal_level"
> postgres=# SELECT pg_start_backup('basebackup', true);
> ERROR: function pg_start_backup("unknown", boolean) does not exist
> HINT: No function matches the given name and argument types. You may need
> to add explicit type casts.
> postgres=# SELECT pg_start_backup('basebackup');
> ERROR: WAL archiving is not active
> HINT: archive_command must be defined before online backups can be made
> safely.
>
>
> The mismatched server version number doesn't look right! Note that this is
> a Postgres 9.0 tarball I've extracted onto a server which already has
> Postgres 8.1.4 installed.
>
> Any thoughts from anybody? Thanks.
>

In my previous response I was assuming you where replacing one version with the
other. More brain cells have woken up and I realized you might also be talking
about running two instances on the same machine at the same time. That is
possible but you will need to have each instance run on a different port in
postgresql.conf (port=? where 5432 is the default). You will also need to make
sure you are using the right program with the right cluster. Currently when you
run psql you are calling the one installed with 9.0.1 which is connecting to
the 8.1.4 cluster, which at a guess is probably running on port 5432. You have
the choice of either specifying full paths to the appropriate binary or
creating sym links.

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com