PostgreSQL

PostgreSQL – convert a user to a role

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

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?

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

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

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

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

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 »

PGCon 2011 begins

PGCon 2011 has started. The formal schedule says Tuesday, but people have already started to arrive in Ottawa and many more start their journeys today. Late last week, there was another flurry of registrations coming in. I saw some today. I expect another peak on Monday as last minute decisions are made. There have been …

PGCon 2011 begins Read More »