Skip to content

=$
|

  • Why upgrade PG?
  • explain.D.C
  • paste.D.C
  • Waiting for …
    • … PostgreSQL 16
    • … PostgreSQL 15
    • … PostgreSQL 14
    • … PostgreSQL 13
    • … PostgreSQL 12
    • … PostgreSQL 11
    • … PostgreSQL 10
    • … PostgreSQL 9.6
    • … PostgreSQL 9.5
    • … PostgreSQL 9.4
    • … PostgreSQL 9.3
    • … PostgreSQL 9.2
    • … PostgreSQL 9.1
    • … PostgreSQL 9.0
    • … PostgreSQL 8.5
    • … PostgreSQL 8.4
  • Projects
  • Contact

Tag: wiki

Don’t do these things in PostgreSQL

In 2018 Lluad created wiki page with couple of rules about what not to do.

Since then there have been 30 changes, done by nine more people.

Based on some conversation on irc I figured I can write a tool to automatically check these rules. Or at least – most of them.

Continue reading Don't do these things in PostgreSQL

Posted on 2020-01-282020-01-28|Tags announcements, pgWikiDont, postgresql, wiki|2 Comments on Don’t do these things in PostgreSQL

How to make backups of PostgreSQL?

Recently someone was looking for help with script from Pg wiki.

I never really checked it, but when talking with the guy needing help, I looked at it. And didn't really like it.

Continue reading How to make backups of PostgreSQL?

Posted on 2013-09-11|Tags backup, linux, pg_dump, postgresql, wiki|12 Comments on How to make backups of PostgreSQL?

Search

Follow me

  • Comments RSS
  • Posts RSS

Popular Posts

  • Waiting for PostgreSQL 15 – JSON_TABLE 1k views | 0 comments
  • Explaining the unexplainable – part 3 292 views | 0 comments
  • System roles – what, why, how? 233 views | 1 comment
  • CHAR(x) vs. VARCHAR(x) vs. VARCHAR vs. TEXT – UPDATED 2010-03-03 230 views | 0 comments
  • Explaining the unexplainable – part 2 213 views | 0 comments
  • Waiting for PostgreSQL 11 – Fast ALTER TABLE ADD COLUMN with a non-NULL default 186 views | 0 comments
  • “ERROR: operator does not exist: integer = text” how to fix it? 157 views | 0 comments
  • How much RAM is PostgreSQL using? 109 views | 0 comments
  • Understanding pg_stat_activity 108 views | 0 comments
  • Explaining the unexplainable 104 views | 0 comments

PostgreSQL

  • Documentation
  • Explain Analyze analyzer
  • IRC help channel
  • Mailing Lists search
  • PG Planet
  • PostgreSQL Home Page

About me

  • CPAN
  • GitLab
  • Linked In
  • Why upgrade PG?
  • explain.D.C
  • paste.D.C
  • Waiting for …
    • … PostgreSQL 16
    • … PostgreSQL 15
    • … PostgreSQL 14
    • … PostgreSQL 13
    • … PostgreSQL 12
    • … PostgreSQL 11
    • … PostgreSQL 10
    • … PostgreSQL 9.6
    • … PostgreSQL 9.5
    • … PostgreSQL 9.4
    • … PostgreSQL 9.3
    • … PostgreSQL 9.2
    • … PostgreSQL 9.1
    • … PostgreSQL 9.0
    • … PostgreSQL 8.5
    • … PostgreSQL 8.4
  • Projects
  • Contact