Difference between revisions of "Talk:PostgreSQL"

From ArchWiki
Jump to: navigation, search
(New page: Updated this wiki to make it more clear and up-to-date.)
 
(Better systemd support)
(9 intermediate revisions by 7 users not shown)
Line 1: Line 1:
Updated this wiki to make it more clear and up-to-date.
+
Updated this wiki to make it more clear and up-to-date. -- Evanlec
 +
 
 +
==  Problem with installation ==
 +
I tried to install postgresql with the wiki, but i found this problem:
 +
pg_ctl: PID file "/var/lib/postgres/data/postmaster.pid" does not exist
 +
Is server running?
 +
 
 +
I searched the forums and I found out that an instruction was missed to do:
 +
 
 +
$ initdb -D /var/lib/postgres/data/
 +
 
 +
I Hope this helps for this wiki
 +
 
 +
 
 +
 
 +
== UTF-8 ==
 +
 
 +
Added instructions on how to create new databases as unicode by default. This seems relevant as the default "encoding" SQL_ASCII is pretty useless for most people. --[[User:Cabrilo|Cabrilo]] 06:15, 11 January 2010 (EST)
 +
 
 +
Is step 4 correct? [[User:Elipsion|Elipsion]] 08:15, 13 January 2010 (EST)
 +
*Good catch. Obviously it wasn't, datistemplate should've been set to TRUE for that database. Thanks for noticing it, I fixed it. --[[User:Cabrilo|Cabrilo]] 12:00, 13 January 2010 (EST)
 +
 
 +
Is this section still necessary?  I am just learning, but did a "show client_encoding" on template1 and it returns UTF8 out of the box. --[[User:Nitmd|Nitmd]] 11:55, 18 September 2010 (CDT)
 +
 
 +
I think it's still necessary (and thank you for making this section). Just removed "vacuum freeze", since it's no longer recommended and the command will be obsolete in future releases of postgresql. BTW: I ran into a problem with the statement to disallow connections to the template1 database. This is because I wanted to build a new database named "postgres". After dropping the postgresql db, creating a new template1 and disallowing the connections to template1, I had no database to connect to, so I couldn't create a new database. Had to delete the data dir and start over.[[User:Tankgrun|Tankgrun]] 10:07, 12 August 2011 (EDT)
 +
 
 +
== Better systemd support ==
 +
 
 +
The wiki is out dated and the package will most certainly not work with systemd without tinkering with the service files. This article needs a re-write. --Newonelectron

Revision as of 06:18, 30 September 2012

Updated this wiki to make it more clear and up-to-date. -- Evanlec

Problem with installation

I tried to install postgresql with the wiki, but i found this problem: pg_ctl: PID file "/var/lib/postgres/data/postmaster.pid" does not exist Is server running?

I searched the forums and I found out that an instruction was missed to do:

$ initdb -D /var/lib/postgres/data/

I Hope this helps for this wiki


UTF-8

Added instructions on how to create new databases as unicode by default. This seems relevant as the default "encoding" SQL_ASCII is pretty useless for most people. --Cabrilo 06:15, 11 January 2010 (EST)

Is step 4 correct? Elipsion 08:15, 13 January 2010 (EST)

  • Good catch. Obviously it wasn't, datistemplate should've been set to TRUE for that database. Thanks for noticing it, I fixed it. --Cabrilo 12:00, 13 January 2010 (EST)

Is this section still necessary? I am just learning, but did a "show client_encoding" on template1 and it returns UTF8 out of the box. --Nitmd 11:55, 18 September 2010 (CDT)

I think it's still necessary (and thank you for making this section). Just removed "vacuum freeze", since it's no longer recommended and the command will be obsolete in future releases of postgresql. BTW: I ran into a problem with the statement to disallow connections to the template1 database. This is because I wanted to build a new database named "postgres". After dropping the postgresql db, creating a new template1 and disallowing the connections to template1, I had no database to connect to, so I couldn't create a new database. Had to delete the data dir and start over.Tankgrun 10:07, 12 August 2011 (EDT)

Better systemd support

The wiki is out dated and the package will most certainly not work with systemd without tinkering with the service files. This article needs a re-write. --Newonelectron