Difference between revisions of "Talk:PostgreSQL"

From ArchWiki
Jump to: navigation, search
Line 2: Line 2:
  
 
==  Problem with installation ==
 
==  Problem with installation ==
I tried install postgresql with the wiki, but i found this problem:
+
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
 
pg_ctl: PID file "/var/lib/postgres/data/postmaster.pid" does not exist
 
Is server running?
 
Is server running?
  
I searched in the forum and I found out that an instruction was missed to do:
+
I searched the forums and I found out that an instruction was missed to do:
  
 
$ initdb -D /var/lib/postgres/data/
 
$ initdb -D /var/lib/postgres/data/

Revision as of 06:26, 11 April 2010

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)