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.


Messages - mrvrmiko

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!

Pages: [1]