Hi, Restore PostgreSQL, the following error occurs: [root@localhost ~]# /opt/bareos/sbin/pgsql-restore -v -c /opt/bareos/etc/bareos/pgsql.conf -w /opt/restore -r horeb restore 2017-07-13 17:07:04 CST INFO: pgsql-restore: ============================= 2017-07-13 17:07:04 CST INFO: pgsql-restore: | PostgreSQL restore utility. | 2017-07-13 17:07:04 CST INFO: pgsql-restore: | (c) 2013 by Inteos | 2017-07-13 17:07:04 CST INFO: pgsql-restore: ============================= 2017-07-13 17:07:04 CST INFO: pgsql-restore: Database RESTORE mode. 2017-07-13 17:07:04 CST INFO: pgsql-restore: CLIENT = client153-fd 2017-07-13 17:07:04 CST INFO: pgsql-restore: PGDATA = /var/lib/pgsql/data 2017-07-13 17:07:04 CST INFO: pgsql-restore: PGHOST = /var/run/postgresql 2017-07-13 17:07:04 CST INFO: pgsql-restore: PGPORT = 5432 2017-07-13 17:07:04 CST INFO: pgsql-restore: PITR until end of WAL data 2017-07-13 17:07:04 CST INFO: pgsql-restore: WHERE = /opt/restore 2017-07-13 17:07:04 CST INFO: pgsql-restore: restoreclient = horeb 2017-07-13 17:07:04 CST INFO: pgsql-restore: postmaster should be already down on that cluster, good. 2017-07-13 17:07:04 CST ERROR: pgsql-restore: CATDB: SQL Exec error! Schema version error 2017-07-13 17:07:04 CST INFO: pgsql-restore: remove old pgdata cluster 2017-07-13 17:07:04 CST INFO: pgsql-restore: connecting to director 2017-07-13 17:07:04 CST ERROR: pgsql-restore: error in director challenge! 2017-07-13 17:07:04 CST ERROR: pgsql-restore: Error connecting to director 2017-07-13 17:07:04 CST ERROR: pgsql-restore: cant restore postgres database 2017-07-13 17:07:04 CST ERROR: pgsql-restore: Aborting! [root@localhost ~]#
my pgsql.conf: # Config file for pgsql plugin # # Where Postgresql data directory is located (pg_cluster) # Plugin will backup this cluster including all defined tablespaces PGDATA = /var/lib/pgsql/data # Where Postgresql socket directory is located PGHOST = /var/run/postgresql # What Postgresql "port" is defined PGPORT = 5432 # You can supply a required pg_ctl startup command including all # required options PGSTART = "/usr/bin/pg_ctl start -D /var/lib/pgsql/data" # The same for a stop command including all required options PGSTOP = "/usr/bin/pg_ctl stop -s -D /var/lib/pgsql/data" # Database name for catalog database CATDB = testdb # Host location for catalog database CATDBHOST = 192.168.1.153 # Port location for catalog database CATDBPORT = 5432 # Catalog database user to connect to CATUSER = horeb # Catalog database User's password CATPASSWD = horeb # Destination for archived wal files. It is a temporary location before # we archive on backup system. ARCHDEST = /tmp/pgsql # Name of archiving client. Name should be unique on every catalog # database. It could be a server name, service name, or other unique # string. You cannot use ':' char in archclient name. This is # simultaneously a name of console resource required for database # restoration. ARCHCLIENT = client153-fd # Bacula Director name used for console resource DIRNAME = bareos-dir # Bacula Director host location used for console resource DIRHOST = 192.168.1.133 # Bacula Director port location used for console resource DIRPORT = 9101 # Console resource password DIRPASSWD = "QnpyMGegZuVO6m9P47EYIhDOm241r7/QeJ3xxjpXgZVJ" How should I do? Thanks! -- You received this message because you are subscribed to the Google Groups "bareos-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to bareos-users+unsubscr...@googlegroups.com. To post to this group, send email to bareos-users@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
