User Craig Ringer - Server Fault

Craig Ringer

Member for 12 years, 4 months
Last seen more than 1 year ago

blog.ringerc.id.au
Western Australia, Australia

97 Answers

Score Activity Newest

170 votes

Accepted

Why does my OpenSSH key fingerprint not match the AWS EC2 console keypair fingerprint?

answered Jun 10, 2014 at 4:28

66 votes

Accepted

What's the difference between sudo su - postgres and sudo -u postgres?

answered Jun 2, 2014 at 8:07

46 votes

Accepted

how to secure an open PostgreSQL port

answered Sep 9, 2014 at 7:03

37 votes

Accepted

kill -9 a postgres process

answered Aug 8, 2012 at 23:57

30 votes

How to set postgresql user password in bash script

answered Nov 9, 2012 at 13:21

29 votes

Completely reset PostgreSQL to default?

answered Feb 11, 2014 at 0:41

28 votes

Accepted

Windows Password won't decrypt on AWS EC2 even with the correct private key

answered Jun 10, 2014 at 4:44

18 votes

Accepted

psql: fe_sendauth: no password supplied

answered Jul 26, 2013 at 0:24

16 votes

Accepted

How to change Postgresql database from Read-only to Writable

answered Sep 24, 2014 at 3:04

10 votes

Accepted

Bad signatures or NOKEY errors on RPMs I just signed

answered Aug 29, 2014 at 9:06

9 votes

Accepted

If I `sudo reboot` my Ubuntu 12.04.2 server with Postgres running, can I lose data?

answered Jun 3, 2013 at 2:31

8 votes

PostgreSQL slow commit performance

answered Mar 22, 2013 at 9:54

7 votes

Accepted

How to restore a file system level copy of a PostgreSQL database (not dump) to a different PC

answered Dec 2, 2011 at 2:20

7 votes

Accepted

Granting rights on postgresql database to another user

answered Nov 30, 2012 at 9:46

7 votes

Accepted

How to set up postgresql on EC2 so my data will be backed up and safe?

answered Nov 24, 2012 at 11:37

7 votes

Accepted

Multiple Postgres Servers (one writer, multiple reader) with Shared Disk

answered Aug 14, 2014 at 5:24

7 votes

Accepted

Using pg_dump when connecting via a service

answered Apr 10, 2014 at 13:52

6 votes

Accepted

Any issues with filesystem-only backups on PostgreSQL?

answered Jan 18, 2014 at 1:30

6 votes

Accepted

How can I determine PostgreSQL's port without root and make it listen to a port?

answered Feb 5, 2014 at 11:45

6 votes

Accepted

Which package to upgrade psql client?

answered Aug 7, 2014 at 0:43

6 votes

.pgpass file does not set default username to connect as

answered Jun 26, 2015 at 18:55

6 votes

terminating connection because of crash of another server process

answered Jul 16, 2015 at 12:14

6 votes

How to do an unattended / silent CPAN install / setup

answered Nov 18, 2016 at 0:36

6 votes

Accepted

Use Let's Encrypt certificates with Postgresql

answered Dec 9, 2016 at 4:09

5 votes

Accepted

pg_dump compression; Server or Client side

answered Sep 30, 2015 at 14:27

5 votes

Where to store VCS version in RPM?

answered Jun 26, 2020 at 2:09

5 votes

Bind mount one container FS tree into another for debug or ephemeral containers?

answered Mar 14, 2022 at 2:39

5 votes

Accepted

Stop postgresql container

answered Sep 1, 2014 at 7:23

5 votes

Postgres: How can I see all SQL statements being executed by the database server?

answered Mar 21, 2013 at 12:28

5 votes

Accepted

Nearest PC equivalent to Mac Target Disk Mode?

answered Jun 6, 2012 at 4:11

1