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. …
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 …
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 …
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 »
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. …
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 …
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 …
The PGCon 2013 Call for papers is out. It’s been out for over two weeks. Had you heard about it already? If you have not already submitted, please do so. The deadline for submissions (19 Jan) is just over a month away. That time will fly past. Please don’t leave it to the last minute. …
The list of talks and speakers for PGCon 2012 has been released. For 2012, we once again have a strong collection of talks that will appeal to a wide range of attendees.
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 …