Show Posts
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
Pages: [1]
1
PostgreSQL / phpPgAdmin
« on: June 04, 2015, 02:38:35 PM »
How to enable PosgreSQL and pgpPgAdmin for web panel users?
2
PostgreSQL / Re: Postgresql Admin Password
« on: June 04, 2015, 02:10:11 PM »
Hello Admins:
About the cuestion, I tried to do since command line, and work well
[root@cwp ~]# su - postgres
-bash-4.1$ createuser usuario
Shall the new role be a superuser? (y/n) yes
-bash-4.1$ createdb testdb
-bash-4.1$ psql
psql (8.4.20)
Type "help" for help.
postgres=# alter user usuariowith encrypted password 'password';
ALTER ROLE
postgres=# grant all privileges on database testdb to usuario;
GRANT
postgres=# \q
-bash-4.1$ exit
logout
[root@cwp ~]# service httpd restart
Stopping httpd: [ OK ]
Starting httpd: httpd: Could not reliably determine the server's fully qualified domain name, using cwp.aoi for ServerName
[ OK ]
[root@cwp ~]# service postgresql restart
Stopping postgresql service: [ OK ]
Starting postgresql service: [ OK ]
Best regards and make the force with u!
About the cuestion, I tried to do since command line, and work well
[root@cwp ~]# su - postgres
-bash-4.1$ createuser usuario
Shall the new role be a superuser? (y/n) yes
-bash-4.1$ createdb testdb
-bash-4.1$ psql
psql (8.4.20)
Type "help" for help.
postgres=# alter user usuariowith encrypted password 'password';
ALTER ROLE
postgres=# grant all privileges on database testdb to usuario;
GRANT
postgres=# \q
-bash-4.1$ exit
logout
[root@cwp ~]# service httpd restart
Stopping httpd: [ OK ]
Starting httpd: httpd: Could not reliably determine the server's fully qualified domain name, using cwp.aoi for ServerName
[ OK ]
[root@cwp ~]# service postgresql restart
Stopping postgresql service: [ OK ]
Starting postgresql service: [ OK ]
Best regards and make the force with u!
Pages: [1]
