Unix & Linux

All Questions

Ask Question
Tagged with
13 questions
Newest
Active
Bountied
Unanswered
Filter by
Sorted by
Tagged with
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
vote
2answers
61 views

(Debian 9) Why is there a postgresql server running on my local machine?

I began following https://www.postgresql.org/docs/9.6/runtime.html for setting up a local postgresql server for testing and development purposes. I discovered that I already have the postgresql ...
2
votes
1answer
39 views

Does 'sudo apt-get purge postgr*' remove database files?

I ran sudo -u postgres psql -c "show data_directory" and it shows /var/lib/postgresql/9.5/main. If I understand correctly, this is the directory that stores the database files. I ran sudo apt-get ...
0
votes
1answer
432 views

PostgreSQL Remote Connection on NAS Synology DS216j

This is what I would like to achieve: I have postgreSQL database running on NAS Synology Diskstation DS216j connected to my router. I want to be able to connect and use the database from remote ...
0
votes
1answer
1k views

No space left on disk (PostgreSQL)

I was trying to write a 55GB SQL file to my database. It used to crash each time. I removed logs and did some cleaning to get the server running, but the transaction never used to complete. Latter, I ...
1
vote
1answer
1k views

PostgreSQL Failed to startup

I am having trouble with starting PostgreSQL on my CentOS system. Here are my error logs below. Any help will be greatly appreciated. 2017-04-25 03:18:12.553 CDT > LOG: could not bind IPv6 socket:...
-2
votes
1answer
532 views

Start PostgreSQL Service Failed [closed]

When I try to start my postgresql server on CentOS I get a message to say that it has failed to start it. I have made sure to initialise the db using "service postgresql initdb". Does anyone have any ...
2
votes
1answer
571 views

Does SQLDriverConnect (from unix-odbc) cache the DSN data? If so, how can I clear/purge it?

While using the UNIX-ODBC libraries from unixodbc site, I'm facing a problem with the SQLDriverConnect api. If I try to connect to my database twice in a row, first with incorrect DSN data (Data ...
0
votes
1answer
2k views

syntax error: unterminated quoted string when using regexp_replace in bash script

I've added some code to the end of a bash script I am using. The code shown here is intended to copy a csv into my postgres table, and then remove brackets, quotes and double quotes from the title ...
3
votes
1answer
3k views

Copy csv data while simultaneously filling serial column

I've created my first postgres table and i'm trying to work out how to copy a .csv file into the table, whilst simultaneously generating a serial number number in column 1 (ID) which starts at number ...
1
vote
1answer
162 views

PostgreSQL Accessible to Web Application

I have a server with PostgreSQL installed and there are scripts that are constantly modifying data in the database. PostgreSQL is running on it's default port 5432. I would like to be able to connect ...
3
votes
2answers
1k views

Simulate PostgreSQL query timeout

I would like to test the behaviour of a program which executes queries to a PostgreSQL server in case of a query timeout. How could I simulate that?
14
votes
2answers
10k views

What network protocols does a Postgres database server use?

I have a postgres 9.1 server running on the default port 5432 on an Ubuntu 12.04 cloud server. I want to open up the port, so I can make remote queries -- but I have to open the port on IP tables, ...