{"action":"closed","issue":{"url":"https://api.github.com/repos/pgbackrest/pgbackrest/issues/541","repository_url":"https://api.github.com/repos/pgbackrest/pgbackrest","labels_url":"https://api.github.com/repos/pgbackrest/pgbackrest/issues/541/labels{/name}","comments_url":"https://api.github.com/repos/pgbackrest/pgbackrest/issues/541/comments","events_url":"https://api.github.com/repos/pgbackrest/pgbackrest/issues/541/events","html_url":"https://github.com/pgbackrest/pgbackrest/issues/541","id":328641427,"node_id":"MDU6SXNzdWUzMjg2NDE0Mjc=","number":541,"title":"Unable to create stanza on repository server","user":{"login":"vancouvertreehouse","id":39840207,"node_id":"MDQ6VXNlcjM5ODQwMjA3","avatar_url":"https://avatars0.githubusercontent.com/u/39840207?v=4","gravatar_id":"","url":"https://api.github.com/users/vancouvertreehouse","html_url":"https://github.com/vancouvertreehouse","followers_url":"https://api.github.com/users/vancouvertreehouse/followers","following_url":"https://api.github.com/users/vancouvertreehouse/following{/other_user}","gists_url":"https://api.github.com/users/vancouvertreehouse/gists{/gist_id}","starred_url":"https://api.github.com/users/vancouvertreehouse/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/vancouvertreehouse/subscriptions","organizations_url":"https://api.github.com/users/vancouvertreehouse/orgs","repos_url":"https://api.github.com/users/vancouvertreehouse/repos","events_url":"https://api.github.com/users/vancouvertreehouse/events{/privacy}","received_events_url":"https://api.github.com/users/vancouvertreehouse/received_events","type":"User","site_admin":false},"labels":[{"id":65354970,"node_id":"MDU6TGFiZWw2NTM1NDk3MA==","url":"https://api.github.com/repos/pgbackrest/pgbackrest/labels/question","name":"question","color":"cc317c","default":true}],"state":"closed","locked":false,"assignee":{"login":"dwsteele","id":5814217,"node_id":"MDQ6VXNlcjU4MTQyMTc=","avatar_url":"https://avatars0.githubusercontent.com/u/5814217?v=4","gravatar_id":"","url":"https://api.github.com/users/dwsteele","html_url":"https://github.com/dwsteele","followers_url":"https://api.github.com/users/dwsteele/followers","following_url":"https://api.github.com/users/dwsteele/following{/other_user}","gists_url":"https://api.github.com/users/dwsteele/gists{/gist_id}","starred_url":"https://api.github.com/users/dwsteele/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dwsteele/subscriptions","organizations_url":"https://api.github.com/users/dwsteele/orgs","repos_url":"https://api.github.com/users/dwsteele/repos","events_url":"https://api.github.com/users/dwsteele/events{/privacy}","received_events_url":"https://api.github.com/users/dwsteele/received_events","type":"User","site_admin":false},"assignees":[{"login":"dwsteele","id":5814217,"node_id":"MDQ6VXNlcjU4MTQyMTc=","avatar_url":"https://avatars0.githubusercontent.com/u/5814217?v=4","gravatar_id":"","url":"https://api.github.com/users/dwsteele","html_url":"https://github.com/dwsteele","followers_url":"https://api.github.com/users/dwsteele/followers","following_url":"https://api.github.com/users/dwsteele/following{/other_user}","gists_url":"https://api.github.com/users/dwsteele/gists{/gist_id}","starred_url":"https://api.github.com/users/dwsteele/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dwsteele/subscriptions","organizations_url":"https://api.github.com/users/dwsteele/orgs","repos_url":"https://api.github.com/users/dwsteele/repos","events_url":"https://api.github.com/users/dwsteele/events{/privacy}","received_events_url":"https://api.github.com/users/dwsteele/received_events","type":"User","site_admin":false}],"milestone":{"url":"https://api.github.com/repos/pgbackrest/pgbackrest/milestones/44","html_url":"https://github.com/pgbackrest/pgbackrest/milestone/44","labels_url":"https://api.github.com/repos/pgbackrest/pgbackrest/milestones/44/labels","id":3368658,"node_id":"MDk6TWlsZXN0b25lMzM2ODY1OA==","number":44,"title":"2.04","description":"","creator":{"login":"dwsteele","id":5814217,"node_id":"MDQ6VXNlcjU4MTQyMTc=","avatar_url":"https://avatars0.githubusercontent.com/u/5814217?v=4","gravatar_id":"","url":"https://api.github.com/users/dwsteele","html_url":"https://github.com/dwsteele","followers_url":"https://api.github.com/users/dwsteele/followers","following_url":"https://api.github.com/users/dwsteele/following{/other_user}","gists_url":"https://api.github.com/users/dwsteele/gists{/gist_id}","starred_url":"https://api.github.com/users/dwsteele/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dwsteele/subscriptions","organizations_url":"https://api.github.com/users/dwsteele/orgs","repos_url":"https://api.github.com/users/dwsteele/repos","events_url":"https://api.github.com/users/dwsteele/events{/privacy}","received_events_url":"https://api.github.com/users/dwsteele/received_events","type":"User","site_admin":false},"open_issues":1,"closed_issues":6,"state":"open","created_at":"2018-05-23T10:29:43Z","updated_at":"2018-06-08T12:38:24Z","due_on":null,"closed_at":null},"comments":2,"created_at":"2018-06-01T19:55:55Z","updated_at":"2018-06-08T12:38:24Z","closed_at":"2018-06-08T12:38:23Z","author_association":"NONE","body":"Please provide the following information when submitting an issue (feature requests or general comments can skip this):\r\n\r\n1. pgBackRest version: \r\n\r\n**2.02**\r\n\r\n2. PostgreSQL version: \r\n\r\n**9.5**\r\n\r\n3. Operating system/version - if you have more than one server (for example, a database server, a repository host server, one or more standbys), please specify each:\r\n\r\n**3.10.0-862.3.2.el7.x86_64 GNU/Linux**\r\n\r\n4. Did you install pgBackRest from source or from a package?\r\n\r\n**Package**\r\n\r\n5. Please attach the following as applicable:\r\n    - `pgbackrest.conf` file(s)\r\n\r\n**REPOSITORY:\r\n\r\nrepo1-path=/data/pgbackrest\r\n\r\n[g01-inst1]\r\npg1-host=<IP Of DB Server>\r\npg1-port=5432\r\npg1-host-user=postgres\r\npg1-path=/pgdata/inst1\r\n\r\nDBServer:\r\n\r\nrepo1-host=<IP of Repository>\r\nrepo1-host-user=pgbackrest\r\nrepo1-path=/data/pgbackrest\r\n\r\n[g01-inst1]\r\npg1-path=/pgdata/inst1\r\npg1-port=5432**\r\n\r\n\r\n    - `postgresql.conf` settings applicable to pgBackRest (`archive_command`, `archive_mode`, `listen_addresses`, `max_wal_senders`, `wal_level`, `port`)\r\n\r\n**I haven't set this up, this is as this requires PostgreSQL restart, I'm trying to get stanza created before I go ahead with setting up archiving command, it allowed me create stanza on test servers without setting up archive_command**\r\n\r\n    - errors in the postgresql log file before or during the time you experienced the issue\r\n\r\n**No**\r\n\r\n    - log file in `/var/log/pgbackrest` for the commands run (e.g. `/var/log/pgbackrest/mystanza_backup.log`)\r\n\r\n\r\n**-------------------PROCESS START-------------------\r\n2018-06-01 12:24:59.505 P00   INFO: stanza-create command begin 2.02: --pg1-host=<myDBServerName> --pg1-host-user=postgres --pg1-path=/pgdata/inst1 --pg1-port=5432 --repo1-path=/data/pgbackrest --stanza=g01-inst1\r\n2018-06-01 12:25:00.781 P00  ERROR: [056]: raised from remote process on '<IP of DB Server>': could not connect to server: No such file or directory\r\n                                                Is the server running locally and accepting\r\n                                                connections on Unix domain socket \"/var/run/postgresql/.s.PGSQL.5432\"?\r\n2018-06-01 12:25:00.786 P00   INFO: stanza-create command end: aborted with exception [056]**\r\n\r\n\r\n7. Describe the issue:\r\n\r\n**I've setup and tested trusted ssh between db server and repository server:\r\n\r\nI'm able to access database from Repository with both postgres user and pgbackrest user.\r\n\r\nI got following error when I tried to create stanza on Repository: $pgbackrest stanza-create --stanza=g01-inst1**\r\n\r\n**ERROR [056]: : raised from remote process on 'IP of DB Server': could not connect to server: No such file or directory\r\n        Is the server running locally and accepting\r\n        connections on Unix domain socket \"/var/run/postgresql/.s.PGSQL.5432\"?**\r\n\r\n\r\n**I've tested this on my testing servers, all work fine.   \r\n\r\nPlease help, thanks!**\r\n\r\n"}}
{"actor":{"display_login":"dwsteele"}}