Questions tagged [centos]

CentOS is a Linux operating system. Questions with this tag should be about administering a database management platform on the CentOS operating system.

Filter by
Sorted by
Tagged with
2
votes
1answer
1k views

Specifying a username while running initdb causes error in log on start of PostgreSQL process

I have been forced to use a different default username for PostgreSQL. Before you ask: no, this is not something I can avoid. It's dumb, I know. Let's move on: In order to do this in an existing Cent ...
4
votes
2answers
18k views

PostgreSQL service start failed on CentOS 7

Installed PostgreSQL using: sudo yum install postgresql-server postgresql-contrib PostgreSQL version: 9.2.18 When start service: sudo service postgresql start Got error: Redirecting to /bin/...
3
votes
2answers
12k views

Changing data directory for postgres on CentOS

I've got a postgres 9.2.18 installation on CentOS which used the standard installation path. Now I realised that on this particular partition, there isn't sufficient hard-disk space for some bigger ...
1
vote
2answers
17k views

How do I uninstall the old version of Postgres on CentOS 7?

I just installed Postgres 9.6 on CentOS 7. However when I run [root@server tmp]# /usr/bin/psql --version psql (PostgreSQL) 9.2.23 It still seems to be pointing to my old version. How do I ...
1
vote
2answers
2k views

postgres user is not superuser

Im having some problems with my postgresql server. In particular, some databases cannot be dropped. On further inspection, I see that the postgres user is not a SuperUser. There are two other users ...
1
vote
1answer
2k views

Host not Allowed Connectivity to MySQL Server

I currently have a website and it references mySQL database. The website uses HTML, CSS and PHP. PHP code embedded inside HTML website, fetches a value and stores it on the SQL database. Then the ...