All Questions
Tagged with postgresql ubuntu
16
questions
0
votes
0answers
13 views
Getting error on ubuntu 18.04 “/usr/lib/postgresql/9.4/bin/repmgr: unrecognized option '--rsync-only'”
I am running the following command for syncing of Postgres DB between node 1 and node 2.
su postgres -c 'repmgr -f /etc/repmgr/repmgr.conf --force --rsync-only -h node2 -d repmgr -U repmgr --verbose ...
-1
votes
2answers
528 views
Ubuntu could not open lock file /var/lib/dpkg/lock - open (13: Permission denied)
I'm trying to create a new user form my rails application. I already ran psql -p 5432 -h localhsot -U postgres and created a new user. Then I added the user with sudo adduser user_name and afterwards ...
0
votes
2answers
903 views
root “su - <user>” got permission denied (Ignored)
Got permission denied when switching user from root to postgres.
No issue switching from root to ubuntu.
root@node-01:~# su - postgres
su: Permission denied
(Ignored)
postgres@node-01:~$ logout
root@...
0
votes
2answers
434 views
Separate systemd script for postgresql instances
I have PostgreSQL-11 installed on Ubuntu 18.04 via apt-get, and based from here, I managed to install 2 instances of postgreSQL on port 5432 and 5433.
My Question is, can I have separate start-stop ...
2
votes
1answer
98 views
Unable to start postgres unless I type the command to restart it
Whenever I try to start my project the following error occurs.
django.db.utils.OperationalError: could not connect to server: No such file or directory
Is the server running locally and ...
5
votes
1answer
5k views
Unable to locate package postgresql-server-dev?
I am trying to install the following packcage postgresql-server-dev-9.5. Using
sudo apt-get install postgresql-server-dev-9.5
Now, after I run this command I get this error:
Unable to locate ...
0
votes
1answer
56 views
Barman >1.5.1 for Ubuntu 16.04
I use Barman 1.5.1 on Ubuntu 16.04.
For several weeks, barman has been working smoothly. Some days ago I noticed something strange.
Instead of backups I find other files in the <SERVER>/base/ ...
0
votes
1answer
664 views
PostgreSql port open on NAS Synology DiskStation (DS216j)
How is possible to check if the port 5432 of my NAS synology DiskStation (DS216j) (IP address 192.168.0.16 ) is open?
I have (in the control panel of the NAS), enabled the firewall and created a rule ...
0
votes
1answer
69 views
PostgreSQL Ubuntu 16.04
I installed PostgreSQL under Ubuntu 16.04 and want to work with a database
postgis_in_action.
I logged into the database and created a schema and two tables.
I'd like to work with pgadminIII and so ...
2
votes
1answer
1k views
Trouble using postgres sql in ubuntu 16.04
I am running Ubuntu 16.04 operating system and have recently installed postgres using the instructions given in https://www.digitalocean.com/community/tutorials/how-to-install-and-use-postgresql-on-...
1
vote
0answers
56 views
Not able to install postgresql in Ubuntu 14.04
I tried many times installing postgresql in Ubuntu 14.04 without success.
I keep getting the following error:
Can't exec "/tmp/postgresql-common.config.WJ3dGb": Permission denied at /usr/share/...
1
vote
0answers
483 views
Installing Ubuntu and PostgreSQL database on different drives
I just received a new root server (this one) with the following drives:
Disk /dev/sda: 480 Gb
Disk /dev/sdb: 480 Gb
Disk /dev/sdc: 240 Gb
Plus the 240Gb SSD.
Both sda and sdb are set up on RAID-1 ...
1
vote
1answer
78 views
Basic Hosting Postgresql in Virtualbox + Ubuntu 14.04
I have configured Postgres to accept network connections from anywhere:
In pg_hga.conf:
host all all 0.0.0.0/0 md5
In postgresql.conf:
listen_addresses = '*'
...
3
votes
1answer
970 views
Stop a process from running on startup without removing it
Just for the heck of it I was running pgrep postgres and got a ton of results:
postgres 1882 1 0 10:06 ? 00:00:00 /usr/lib/postgresql/9.3/bin/postgres -D /var/lib/postgresql/9.3/main -c ...
6
votes
3answers
1k views
Passwords for newly created users?
I am fairly new to Linux and I have question regarding users. When I use the useradd command I don't specify a password. I must use the passwd command afterwards. Does this mean that the user is ...
3
votes
1answer
2k views
Is it possible to import vmail folder from old iRedMail to new iRedMail installation?
Basically, what I did:
Copied vmail folder to my local machine.
Reinstalled my VPS.
Installed iRedMail again.
Created same users on the same domain.
Question is - can I somehow copy over my old ...
