The message "The database system is starting up." does not indicate an error. The reason it is at the FATAL level is so that it will always make it to the log, regardless of the setting of log_min_messages:
http://www.postgresql.org/docs/9.1/interactive/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHEN
After the rsync, did you really run what you show?:
pgsql -c "select pg_stop_backup();";
Since there is, so far as I know, no pgsql executable, that would leave the backup uncompleted, and the slave would never come out of recovery mode. On the other hand, maybe you really did run psql, because otherwise I don't see how the slave would have logged such success messages as:
Log: consistent recovery state reached at 0/BF0000B0
and:
Log: streaming replication successfully connected to primary
Did you try connecting to the slave at this point? What happened?
The "Success. You can now start..." message you mention is generated by initdb, which shouldn't be run as part of setting up a slave; so I think you may be confused about something there. I'm also concerned about these apparently conflicting statements:
The only ways I have restarted Postgres is through the service
postgresql-9.1 restart or /etc/init.d/postgresql-9.1 restart commands.
After I receive this error, I kill all processes and again try to
restart the database...
Did you try to stop the service through the service script? What happened? It might help in understanding the logs if you prefixed lines with more information. We use:
log_line_prefix = '[%m] %p %q<%u %d %r> '
The recovery.conf script looks odd. Are you copying from the master's pg_xlog directory, the slave's active pg_xlog directory, or an archive directory?
There are various ways to set the search_path in PostgreSQL.
To diagnose, log into the same database as the same superuser and check:
SHOW search_path;
If it contains dbms_sql, then check your postgresql.conf, databse and role settings to find where it came from.
Use any editor or for instance grep on in a Linux shell to audit postgresql.conf:
grep 'search_path' /your/path/to/postgresql.conf
To check on database and role settings, use the default command line client psql or a graphical GUI like pgAdmin.
In pgAdmin you just select the object in the object browser to see all settings in the SQL pane.
In psql, use
\drds superuser
to see settings for this role. And
\drds '' db_name
to see settings for the database. Or just
\drds
to see all settings for all roles and databases.
Best Answer
In psql, the -v option takes an argument. It does not mean verbose, like it does for pg_dump. So the -v 'eats' the -h, considering an argument to -v. That leaves postgres.dolphin.com as being just a bare argument not belonging to any option. Normally that would be interpreted as the database name or as the user name, but since you already have
-d somethingand-U something, that doesn't work. So it doesn't what to do with this bare argument, and complains.