PostgreSQL: Difference between revisions
imported>Qknight added some documentation how to debug the SQL statements |
imported>Ariutta m Specify updated package name. Close brace. |
||
Line 36: | Line 36: | ||
services.postgresql = { | services.postgresql = { | ||
enable = true; | enable = true; | ||
package = pkgs. | package = pkgs.postgresql_10; | ||
enableTCPIP = true; | enableTCPIP = true; | ||
authentication = pkgs.lib.mkOverride 10 '' | authentication = pkgs.lib.mkOverride 10 '' | ||
Line 47: | Line 47: | ||
GRANT ALL PRIVILEGES ON DATABASE nixcloud TO nixcloud; | GRANT ALL PRIVILEGES ON DATABASE nixcloud TO nixcloud; | ||
''; | ''; | ||
}; | |||
</pre> | </pre> | ||