From YaST, select the System icon and then the System Services icon. Find the
PostgreSQL item, and then enable it to autostart.
Accessing PostgreSQL
In openSUSE, the PostgreSQL server is configured slightly different than the MySQL
server. If you remember, the MySQL server maintains its own internal database of users
that can be granted access to database objects. While PostgreSQL also has this capability,
the openSUSE implementation utilizes the existing openSUSE system user files to authenticate
PostgreSQL user accounts.
While this can sometimes be confusing, it does make for a nice clean way to control user
accounts in PostgreSQL. Another major difference for PostgreSQL is that the administrator
account in PostgreSQL is called postgres, not Root. The openSUSE PostgreSQL installation
automatically creates a system account called postgres and assigns it an unknown password
so that you can??™t log into the system with it.
Similar to MySQL, PostgreSQL uses a command line client to interact with the server. The
PostgreSQL command line client is called psql.
Pages:
1127
1128
1129
1130
1131
1132
1133
1134
1135
1136
1137
1138
1139
1140
1141
1142
1143
1144
1145
1146
1147
1148
1149
1150
1151