Well, d/rake autospec did yield 14 failures, the first 6 of which seem to be related to the PEER authentication issue.
Can’t make heads or tails of it but thought I’d post it here for when someone is able to investigate. Looks like the same error but with different Postgres versions everytime.
Hope this helps
Failures:
1) BackupRestore::DatabaseRestorer#restore with real psql restores from PostgreSQL 9.5
Failure/Error: raise DatabaseRestoreError.new("psql failed: #{last_line}") if Process.last_status&.exitstatus != 0
BackupRestore::DatabaseRestoreError:
psql failed: psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL: Peer authentication failed for user "postgres"
# ./lib/backup_restore/database_restorer.rb:92:in `restore_dump'
# ./lib/backup_restore/database_restorer.rb:26:in `restore'
# ./spec/lib/backup_restore/shared_context_for_backup_restore.rb:59:in `execute_stubbed_restore'
# ./spec/lib/backup_restore/database_restorer_spec.rb:41:in `restore'
# ./spec/lib/backup_restore/database_restorer_spec.rb:45:in `expect_restore_to_work'
# ./spec/lib/backup_restore/database_restorer_spec.rb:61:in `block (4 levels) in <main>'
# ./spec/rails_helper.rb:284:in `block (2 levels) in <top (required)>'
2) BackupRestore::DatabaseRestorer#restore with real psql restores from PostgreSQL 9.3
Failure/Error: raise DatabaseRestoreError.new("psql failed: #{last_line}") if Process.last_status&.exitstatus != 0
BackupRestore::DatabaseRestoreError:
psql failed: psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL: Peer authentication failed for user "postgres"
# ./lib/backup_restore/database_restorer.rb:92:in `restore_dump'
# ./lib/backup_restore/database_restorer.rb:26:in `restore'
# ./spec/lib/backup_restore/shared_context_for_backup_restore.rb:59:in `execute_stubbed_restore'
# ./spec/lib/backup_restore/database_restorer_spec.rb:41:in `restore'
# ./spec/lib/backup_restore/database_restorer_spec.rb:45:in `expect_restore_to_work'
# ./spec/lib/backup_restore/database_restorer_spec.rb:51:in `block (4 levels) in <main>'
# ./spec/rails_helper.rb:284:in `block (2 levels) in <top (required)>'
3) BackupRestore::DatabaseRestorer#restore with real psql restores from PostgreSQL 12
Failure/Error: raise DatabaseRestoreError.new("psql failed: #{last_line}") if Process.last_status&.exitstatus != 0
BackupRestore::DatabaseRestoreError:
psql failed: psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL: Peer authentication failed for user "postgres"
# ./lib/backup_restore/database_restorer.rb:92:in `restore_dump'
# ./lib/backup_restore/database_restorer.rb:26:in `restore'
# ./spec/lib/backup_restore/shared_context_for_backup_restore.rb:59:in `execute_stubbed_restore'
# ./spec/lib/backup_restore/database_restorer_spec.rb:41:in `restore'
# ./spec/lib/backup_restore/database_restorer_spec.rb:45:in `expect_restore_to_work'
# ./spec/lib/backup_restore/database_restorer_spec.rb:74:in `block (4 levels) in <main>'
# ./spec/rails_helper.rb:284:in `block (2 levels) in <top (required)>'
4) BackupRestore::DatabaseRestorer#restore with real psql restores from PostgreSQL 11
Failure/Error: raise DatabaseRestoreError.new("psql failed: #{last_line}") if Process.last_status&.exitstatus != 0
BackupRestore::DatabaseRestoreError:
psql failed: psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL: Peer authentication failed for user "postgres"
# ./lib/backup_restore/database_restorer.rb:92:in `restore_dump'
# ./lib/backup_restore/database_restorer.rb:26:in `restore'
# ./spec/lib/backup_restore/shared_context_for_backup_restore.rb:59:in `execute_stubbed_restore'
# ./spec/lib/backup_restore/database_restorer_spec.rb:41:in `restore'
# ./spec/lib/backup_restore/database_restorer_spec.rb:45:in `expect_restore_to_work'
# ./spec/lib/backup_restore/database_restorer_spec.rb:70:in `block (4 levels) in <main>'
# ./spec/rails_helper.rb:284:in `block (2 levels) in <top (required)>'
5) BackupRestore::DatabaseRestorer#restore with real psql restores from PostgreSQL 9.5.5
Failure/Error: raise DatabaseRestoreError.new("psql failed: #{last_line}") if Process.last_status&.exitstatus != 0
BackupRestore::DatabaseRestoreError:
psql failed: psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL: Peer authentication failed for user "postgres"
# ./lib/backup_restore/database_restorer.rb:92:in `restore_dump'
# ./lib/backup_restore/database_restorer.rb:26:in `restore'
# ./spec/lib/backup_restore/shared_context_for_backup_restore.rb:59:in `execute_stubbed_restore'
# ./spec/lib/backup_restore/database_restorer_spec.rb:41:in `restore'
# ./spec/lib/backup_restore/database_restorer_spec.rb:45:in `expect_restore_to_work'
# ./spec/lib/backup_restore/database_restorer_spec.rb:56:in `block (4 levels) in <main>'
# ./spec/rails_helper.rb:284:in `block (2 levels) in <top (required)>'
6) BackupRestore::DatabaseRestorer#restore with real psql restores from PostgreSQL 10
Failure/Error: raise DatabaseRestoreError.new("psql failed: #{last_line}") if Process.last_status&.exitstatus != 0
BackupRestore::DatabaseRestoreError:
psql failed: psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL: Peer authentication failed for user "postgres"
# ./lib/backup_restore/database_restorer.rb:92:in `restore_dump'
# ./lib/backup_restore/database_restorer.rb:26:in `restore'
# ./spec/lib/backup_restore/shared_context_for_backup_restore.rb:59:in `execute_stubbed_restore'
# ./spec/lib/backup_restore/database_restorer_spec.rb:41:in `restore'
# ./spec/lib/backup_restore/database_restorer_spec.rb:45:in `expect_restore_to_work'
# ./spec/lib/backup_restore/database_restorer_spec.rb:66:in `block (4 levels) in <main>'
# ./spec/rails_helper.rb:284:in `block (2 levels) in <top (required)>'