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: postgres

Why is there database named “postgres”?

Every so often, on irc, someone asks if they can remove postgres database, and why is it even there.

Figured I can write one blogpost to answer it once and for all, and use it as ready answer whenever the question resurfaces.

Continue reading Why is there database named “postgres"?

Posted on 2021-02-09|Tags cleanup, postgres, postgresql, tools, tutorial|8 Comments on Why is there database named “postgres”?

Search

Follow me

  • Comments RSS
  • Posts RSS

Popular Posts

  • Variables in psql, how to use them? 1k views | 2 comments
  • Explaining the unexplainable – part 2 214 views | 0 comments
  • CHAR(x) vs. VARCHAR(x) vs. VARCHAR vs. TEXT – UPDATED 2010-03-03 213 views | 0 comments
  • Explaining the unexplainable – part 3 210 views | 0 comments
  • Waiting for PostgreSQL 11 – Fast ALTER TABLE ADD COLUMN with a non-NULL default 164 views | 0 comments
  • “ERROR: operator does not exist: integer = text” how to fix it? 149 views | 0 comments
  • Understanding pg_stat_activity 128 views | 0 comments
  • To rule or not to rule – that is the question 103 views | 0 comments
  • How to run short ALTER TABLE without long locking concurrent queries 96 views | 0 comments
  • Why is UPSERT so complicated? 88 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