Hi dear members,
I am new postgresSQL, still trying to get the knowledge. As per client requirement I need to migrate postgres DB to new server, but I am having trouble doing that and couldn’t find any help,
Following are the summery what I am facing and some details I have gathered,
1. Old psql (PostgreSQL) 7.4.5 , OS - SUN 5.9
2. New postgres version 8.2, OS – SUN 5.10
# pkginfo | grep post
GNOME2 SUNWgnome-ps-viewer GNOME post script viewer - platform dependent files, /usr filesystem
GNOME2 SUNWgnome-ps-viewer-root GNOME post script viewer - platform dependent files, / filesystem
GNOME2 SUNWgnome-ps-viewer-share GNOME post script viewer - platform independent files, /usr/share
system SUNWj3cfg SUNWj3rt post configuration
system SUNWpostgr PostgreSQL 8.1.19 client programs and libraries
system SUNWpostgr-82-client PostgreSQL 8.2 client tools
system SUNWpostgr-82-contrib PostgreSQL 8.2 community contributed tools not part of core product
system SUNWpostgr-82-devel PostgreSQL 8.2 development tools and header files
system SUNWpostgr-82-docs PostgreSQL 8.2 documentation and man pages
system SUNWpostgr-82-jdbc JDBC 3 driver for PostgreSQL 8.2
system SUNWpostgr-82-libs PostgreSQL 8.2 client libraries
system SUNWpostgr-82-pl PostgreSQL 8.2 additional Perl, Python & TCL server procedural languages
system SUNWpostgr-82-server PostgreSQL 8.2 database server
system SUNWpostgr-82-server-data-root PostgreSQL 8.2 database server data directories and root components
system SUNWpostgr-82-tcl Tcl binding library for PostgreSQL 8.2
system SUNWpostgr-83-client PostgreSQL client tools
system SUNWpostgr-83-contrib PostgreSQL community contributed tools not part of core product
system SUNWpostgr-83-devel PostgreSQL development tools and header files
system SUNWpostgr-83-docs PostgreSQL documentation and man pages
system SUNWpostgr-83-libs PostgreSQL client libraries
system SUNWpostgr-83-pl PostgreSQL additional Perl, Python & TCL server procedural languages
system SUNWpostgr-83-server PostgreSQL database server
system SUNWpostgr-83-server-data-root PostgreSQL database server data directories and root components
system SUNWpostgr-83-tcl Tcl binding library for PostgreSQL
system SUNWpostgr-contrib Contributed source and binaries distributed with PostgreSQL 8.1.19
system SUNWpostgr-devel PostgreSQL 8.1.19 development header files and libraries
system SUNWpostgr-docs Extra documentation for PostgreSQL 8.1.19
system SUNWpostgr-jdbc JDBC drivers for PostgreSQL
system SUNWpostgr-libs The shared libraries required for any PostgreSQL 8.1.19 clients
system SUNWpostgr-pl The PL procedural languages for PostgreSQL 8.1.19
system SUNWpostgr-server The programs needed to create and run a PostgreSQL 8.1.19 server
system SUNWpostgr-server-data The data directories needed to create and run a PostgreSQL 8.1.19 server
system SUNWpostgr-tcl A Tcl client library for PostgreSQL
system SUNWpostgr-upgrade Tools to upgrade from older PostgreSQL versions
GNOME2 SUNWpostrun Delayed execution environment for procedural package scripts
GNOME2 SUNWpostrun-root Delayed execution environment for procedural package scripts - / filesystem
#
The Command used to start DB,
$ pg_ctl start -l /tmp/pglog.txt -D /usr/local/pgsql/data
pg_ctl: another postmaster may be running; trying to start postmaster anyway
pg_ctl: could not start postmaster
Examine the log output.
$
The log file output,
$ cat pglog.txt
FATAL: unrecognized configuration parameter "syslog"
$
You feedbacks are mostly welcome.