PostgreSQL, often simply Postgres, is an object-relational database management system (ORDBMS) available for many platforms including Linux, FreeBSD, Solaris, Microsoft Windows and Mac OS X.
-1
votes
0answers
20 views
Reccomended OS Linux on virtual machine to use the following tools [closed]
I need on this OS of PostgreSQL, Eclipse, GWT, JDBC, Apache Tomcat, Chrome, Mercurial Eclipse Plugin. What would you suggest? I would prefer it was similiar to Debian 7. Thanks a lot!
0
votes
0answers
10 views
I have error in postgresql service
Today I would like to test my metasploit. So, first I run service postgresql start, so here problems:
root@localhost:/# service postgresql start
[....]
Starting PostgreSQL 9.1 database server: main
...
0
votes
1answer
58 views
ufw won't allow connections to port 5432
I've installed Postgresql 9.4 on Ubuntu Trusty from the PGDG ppa. I've created a database and set it listen-addresses to '*'. I've made an entry in the pg_hba.conf file. I can connect locally with no ...
1
vote
1answer
61 views
What does exit code 130 mean for postgres command?
When attempting to start PostgreSQL server using the /usr/pgsql-9.2/bin/postgres command I get an exit value code of 130.
However I could not find any documentation for the exit codes of this ...
0
votes
1answer
41 views
.sh script error issues
I have a sh script with which I connect to postgres DB and execute a psql command. The script is as shown below:
/opt/postgres/9.2/bin/psql pcwh -U pcwhuser << EOF
\i ...
1
vote
1answer
39 views
File/directory not being deleted?
Please see the screenshot. The image on the left says existing x installation found at /opt/x
The image on the right shows the terminal where I attempt to delete the same directory.
The terminal on ...
0
votes
1answer
56 views
Systemd postgresql start script
I'm in the process of installing postgresql onto a second server
Previously I installed postgresql and then used the supplied script
./contrib/start-scripts/linux
Placed into the correct dir
# cp ...
4
votes
1answer
68 views
unable to connect to forwarded port over ssh
I have two servers. Server 1 has access to an Oracle instance on a server I have permission to hit but not login to via SSH. I would like to use SSH port forwarding to connect from server 2 to server ...
0
votes
2answers
44 views
Is there an easy foolproof way to translate commands from Ubuntu to Debian, and vice-versa?
If I want to work between Ubuntu and Debian or switch to one or the other, would there be a good way to know what commands will work on both?
I have set up Debian with sudo (i.e. by not choosing a ...
1
vote
2answers
24 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?
0
votes
0answers
9 views
How to make roundcube work with pgsql?
roundcube & pgsql are running on different containers
docker run --name to-postgres --expose 5342 -e POSTGRES_USER=roundcube -e POSTGRES_PASSWORD=roundcube -d postgres
Now how shall I install ...
0
votes
0answers
74 views
can't run pgadmin3 on fedora22
i installed postgresql and pgadmin. when i try running pgadmin this is what i get:
Warning: Mismatch between the program and library build versions detected.
The library used 2.8 (no ...
0
votes
0answers
193 views
problem installing postgresql (opengeo) on fedora 22
I'm following the directions found at http://suite.opengeo.org/4.1/installation/redhat/install.html
i created gedit /etc/yum.repos.d/OpenGeo.repo with the following text:
[opengeo]
name=opengeo
...
1
vote
2answers
199 views
Permanently change permissions of /var/run/postgresql
On Linux Mint 17.0 Cinnamon Edition, I want to use /var/run/postgresql as the unix_socket_directories option for all of my postgres databases.
Whenever I run the command pg_ctl -D postgres-data -o ...
2
votes
1answer
2k views
Postgresql wont start after reboot. Kali linux Raspberry Pi 2 [duplicate]
I have been trying for days to get postgresql to work and it did briefly before a restart. How to I set the correct permissions? This is the error I get when I try to start the service after a reboot.
...
3
votes
3answers
2k views
How to solve the problem of PostgreSQL service doesn't start?
This is about Metasploit Framework.
root@kali:~# service postgresql start
[....] Starting PostgreSQL 9.1 database server: main[....] The
PostgreSQL server failed to start. Please check the log ...
1
vote
0answers
179 views
GitLab install: psql error “role ”git“ does not exist” [closed]
I'm new to Unix administration. I have a virtual machine with FreeBSD 10.1 and I would like to install GitLab.
I used this guide to install it, but on step 4 it doesn't work:
...
0
votes
1answer
3k views
Command to list PostgreSQL user accounts?
There are createuser & dropuser commands:
createuser - define a new PostgreSQL user account
dropuser - remove a PostgreSQL user account
Is there a corresponding way to list the user accounts?
...
0
votes
2answers
117 views
many missing dependencies , no links (centOS 7 , postgresql 9.3)
I am trying to install postgresql 9.3 on centOS 7
first , I needed to install libxml2 , and then I tried to install libxml2-devel
/$ rpm -iUvh
...
0
votes
2answers
687 views
Centos 7 - Trying to install postgresql (from postgresql.org)
I am trying to install Socorro service on fresh Centos 7 (installed on Amazon ec2). I am following the instructions from the official documentation - Socorro. I installed the PostgreSQL 9.3 RPM ...
0
votes
0answers
239 views
Why does PostgreSQL 9.4 on CentOS7 not run via the `systemd` service file on boot?
As root, if I change to the postgres user with su -l postgres then run /usr/pgsql-9.4/bin/pg_ctl start -D ${PGDATA} -s -w -t 300, PostgreSQL starts successfully.
As root, if I run systemctl start ...
0
votes
2answers
3k views
Shell script to execute psql command [closed]
I want to make an automated script to make a database user and password in Postgresql and also import some databases. When i execute my script bellow it stops somewhere and when i log out (CTRL+D or ...
0
votes
2answers
105 views
How to connect to PostgreSQL 9 from Drupal 7?
I want to connect to PostgreSQL 9 from Drupal 7.
to install drupal files using the following steps.
wget http://ftp.drupal.org/files/projects/drupal-7.15.tar.gz
tar zxvf drupal-7.15.tar.gz ...
0
votes
0answers
419 views
Centos 7, Postgresql 9.4 Failed to Read Permission Data Directory in mounted Partition
I've a problem with start PostgreSQL 9.4 on Centos 7 Server. Because the partition /var/lib/pgsql/9.4/data/ (which contains PostgreSQL data is full) so I want to change to another partition.
...
0
votes
1answer
86 views
Centos & PostgreSQL - cannot create database cluster
I have a server with CentOS 6. I installed on it postgreSQL 9.4, but didn't tell my mate and he installed 8.4 which included in CentOS by default. So we removed (service remove postgresql) both of ...
0
votes
0answers
265 views
PgBouncer is running, but cannot connect
PgBouncer started using pgbouncer -d -v pgbouncer.ini.
pgbouncer.log file:
Actually, every line in this file begins with a date/time stamp
of 2015-01-19 11:37:46.415 (first 7 lines)
or 2015-01-19 ...
1
vote
2answers
224 views
pgbouncer startup problem
I followed the steps from http://www.guguncube.com/1692/pgbouncer-installation-and-configuration-in-ubuntu for pgbouncer setup.
When I start pgbouncer, I get the error
Cannot open logfile: ...
10
votes
1answer
382 views
Why does `postgres` require a shell?
In my Debian Wheezy systems, I noticed that the postgres user 'postgres', the "PostgreSQL administrator", uses /bin/bash as shell.
However, I cannot figure out why this is needed. Changing this to ...
0
votes
1answer
60 views
DB Synchronization between main and DR site
I hope I am asking this question in the correct section.
I have an environment setup for my application which consists of master / slave Postgresql databases. The master and slave are being ...
2
votes
1answer
145 views
Command-line editing and wrapping
When entering long queries into the command-line psql, my terminal[1] is not wrapping the input line correctly. Additional charactes wrap back to the left of the screen, but on the same line as the ...
1
vote
0answers
1k views
ERROR: Failed to build gem native extension on Arch (postgresql)
I can't install gem pg on Arch due to the error:
Gem::Ext::BuildError: ERROR: Failed to build gem native extension.
/home/alex/.rvm/rubies/ruby-2.1.1/bin/ruby extconf.rb
checking for ...
1
vote
0answers
1k views
Postgresql 9.1 - Kali Linux
I start to read this book : http://www.amazon.fr/Metasploit-The-Penetration-Testers-Guide/dp/159327288X
And i have some trouble in using postgresql 9.1 (in Kali Linux).
When i start msfconsole, i ...
1
vote
0answers
364 views
PostgreSQL installation error in debian
I'm trying to install PgSql in the system with following specs:
Distributor ID: Debian
Description: Debian GNU/Linux 7.1
Release: 7.1
x86_64
But I am getting an error like this
The ...
1
vote
1answer
2k views
Kali Linux Postgresql Error
I recently installed kali Linux and keep getting an error code starting metasploit this is the code
[...] Starting PostgreSQL 9.1 database server: main
[...] Error: could not exec ...
0
votes
1answer
1k views
Server Not accepting TCP/IP Connections
I have a Wt application running in a CentOS server machine(Machine A) in the port number 9798. Application is up and I could view the web page with the URL,
http://localhost:9798
But application ...
1
vote
0answers
72 views
Add Solaris utf-8 support for Postgresql
I need to use utf-8, but "locale -a" produces:
C
POSIX
iso_8859_1
the os is:
SunOS cteraportal 5.11 NexentaOS_134f i86pc i386 i86pc Solaris
Additional info:
root@cteraportal:~# dpkg -l locales
...
1
vote
1answer
444 views
Postgres: authenticate as postgres user in non-interactive script
I am writing a non-interactive script that needs to execute postgres commands. The script will only be run by root or a user with sudo permissions, and the postgres commands need to be executed as ...
3
votes
2answers
299 views
What network protocols do database servers 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, ...
1
vote
0answers
484 views
Passing escape sequences to shells within ansi-term in Emacs
In a regular terminal (e.g. iTerm2 on OS X) I can connect to a database, e.g.
> psql ....
and then, as I type my command in psql, e.g.
$ select foo from bar
I can move around (as I type psql ...
0
votes
1answer
399 views
Adding Postgres bins to PATH: should I `export`? [duplicate]
I'm on a Mac, but this seems like a UNIX/Linux question. I just installed Postgres.app, and the documentation says to add the /bin directory that ships with Postgres.app to your PATH by adding the ...
0
votes
1answer
668 views
cannot start PostgreSQL on OpenBSD 5.4 through rc.d
I've installed the postgresql-server package on OpenBSD 5.4 amd64, and I try starting it through its rc.d script, however, it doesn't look like it's running after that.
opti# /etc/rc.d/postgresql ...
1
vote
3answers
2k views
CentOS 5: My Postgresql server version is different with my psql client. What should I do?
I installed PostgreSQL 9.1 in CentOS 5 x86_64 VPS, with these following commands:
I specified which Postgresql version I'd like to install, so I choose 9.1 because I want to equate between ...
2
votes
2answers
2k views
Incremental backup of postgresql database
We run a database server running PostgreSQL with database size of around 130GB growing at a rate of 500MB per day. We use HP Data Protector software to take backups of the database.
The issue here is ...
1
vote
3answers
2k views
Installing PostgreSQL 9.0 on RHEL 6.4 (How to get Yum to Include a version of OpenSSL I built from source)
I receive the following errors from yum install postgresql90-server:
Error: Package: postgresql90-9.0.15-1PGDG.rhel6.x86_64 (pgdg90)
Requires: libssl.so.10(libssl.so.10)(64bit)
Error: Package: ...
2
votes
2answers
402 views
Logic behind Postgres binary installation path on Debian
It appears that the Postgresql installation is split into three folder locations on Debian:
Configuration: /etc/postgresql
Binaries: /usr/lib/postgresql
Data: /var/lib/postgresql
I ...
0
votes
0answers
269 views
Postgresql 9.3 with posgis extenstions not working after restart
I'm running Mint 16.
In pgAdmin it gives me this output.
An error has occurred:
ERROR: could not load library "/usr/lib/postgresql/9.3/lib/postgis-2.1.so": libjson.so.0: cannot open shared ...
6
votes
3answers
298 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 ...
1
vote
1answer
68 views
how to configure postgresql to log in remotely and locally
In order to be able to connect to my postgresql database from another machine, I had to configure my postgresql.conf file like so:
...
2
votes
1answer
371 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 ...
5
votes
2answers
3k views
How to install PostgreSQL 9.3 in FreeBSD jail?
I configured virtual NICS using pf, and a jail for FreeBSD using qjail create pgsql-jail 192.168.0.3.
When I tried to install PostgreSQL 9.3 using port collection, it shows strange message at first.
...
