PostgreSQL – Dan Langille's Other Diary

Moving local settings for pg_hba.conf and postgresql.conf out of PGDATA

2 Comments / FreeBSD, Open Source, PostgreSQL / By Dan Langille / February 18, 2024 / PostgreSQL

One of the configuration aspects of FreeBSD I have long liked is the concept of default values which are overridden by the user. For example, /etc/defaults/rc.conf (see The /etc directory). The default values in this file can be overridden by the user with their preferred values in /etc/rc.conf (or /etc/rc.conf.local, and other locations if you […]

Moving local settings for pg_hba.conf and postgresql.conf out of PGDATA Read More »

I figured out why pg_dump was failing with PostgreSQL 15-16

Leave a Comment / Bacula, FreeBSD, Open Source, PostgreSQL / By Dan Langille / November 22, 2023 / PostgreSQL

In recent blog post, I outlined a problem I hit with pg_dump. Specifically, pg_dump was picking up and using ~/.pgpass with pg_dump from PostgreSQL 12-14, but with PostgreSQL 15-16, it was failing. In this blog post: FreeBSD 13.2 PostgreSQL server 12 / 16 PostgreSQL client 12-16 Bacula 9.6.7 Today we figured out why: $HOME. $HOME

I figured out why pg_dump was failing with PostgreSQL 15-16 Read More »

pg_dump: error: connection to server failed: fe_sendauth: no password supplied

2 Comments / Bacula, Open Source, PostgreSQL / By Dan Langille / November 20, 2023 / PostgreSQL

FYI, this problem has been solved and described in I figured out why pg_dump was failing with PostgreSQL 15-16. This morning I encountered this error message: In this post: FreeBSD 13.2 PostgreSQL 12.16 (server – pg02) PostgreSQL 16.1 (client – dbclone) See also While restoring my PostgreSQL database to a new FreeBSD server, I discovered

pg_dump: error: connection to server failed: fe_sendauth: no password supplied Read More »

PostgreSQL – convert a user to a role

Leave a Comment / PostgreSQL / By Dan Langille / August 9, 2018 / PostgreSQL

Users and Roles in PostgreSQL are very similar. When I set up the FreshPorts database back in mid-2000, I was using PostgreSQL 7.0.3 (that’s my best guess based on my blog entry). I suspect roles were not available then and were introduced with PostgreSQL 8. I am positive someone will correct me if that’s wrong.

PostgreSQL – convert a user to a role Read More »

PostgreSQL – logging to a file

Leave a Comment / PostgreSQL, syslog / By Dan Langille / July 31, 2017 / PostgreSQL

These steps were carried out on FreeBSD 11.0 with PostgreSQL 9.6 (two of my favorite tools). I like logging. I like logging PostgreSQL. With logs, you can see what happened. Without, you can only guess. Setting up logging for PostgreSQL involves several parts, each of which must be completed or else I don’t get what

PostgreSQL – logging to a file Read More »

Have you never been to PGCon?

Leave a Comment / Conferences, Conventions, PGCon / By Dan Langille / April 15, 2014 / PostgreSQL

I remember a time when I’d never been to a conference related to my passions. Once I went, things changed. I realized that making strong working relationships with others who share my passion is important. Not only does this solidify the community of which you are a member, it also helps you personally. Every conference

Have you never been to PGCon? Read More »

pg_restore: [custom archiver] could not read from input file: end of file

3 Comments / PostgreSQL / By Dan Langille / June 12, 2013 / PostgreSQL

I’ve been a fan of PostgreSQL since 2000 when I switched to it from MySQL. I wanted stored procedures and functions. I got that with PostgreSQL. I was used to having such features from my years working with other big databases such as DB2, Oracle, and Sybase. I’ve been moving towards using the custom format

pg_restore: [custom archiver] could not read from input file: end of file Read More »

Using compression with PostgreSQL’s pg_dump

4 Comments / databases, Open Source, PostgreSQL / By Dan Langille / June 10, 2013 / PostgreSQL

I attended a few of the talks at PGCon 2013 last month. One talk, for which I took several notes and made a few choice tweets. The main one I’m following up on is using the -Fc option on pg_dump. It was during Magnus Haganders’ talk on PostgreSQL Backup Strategies that I posted that tweet.

Using compression with PostgreSQL’s pg_dump Read More »

Restricting IP addresses to specific databases

1 Comment / Open Source, PostgreSQL / By Dan Langille / May 10, 2013 / PostgreSQL

Sometimes, you don’t want just anyone talking to your database. In fact, sometimes, you don’t want anyone accessing your database except very specific applications. In this case, I am setting up about 20 databases, each one dedicated to a specific use, and to be accessed only from one IP address each. In this post, I’ll

Restricting IP addresses to specific databases Read More »

PGCon 2013 registration is now open

Leave a Comment / Conferences, PGCon / By Dan Langille / March 28, 2013 / PostgreSQL

PGCon 2013 is coming up soon. We’ve had confirmation from EnterpriseDB that they be hosting a social event on the Thursday night. You’ll have heard about this party from 2012, seen the pictures, and wish you’d been there. This year, they are going back to the same venue again this year. Of course, in addition

PGCon 2013 registration is now open Read More »