On 2014-06-17, 8:08 AM, Khangelani Gama wrote:
I keep getting the following error when trying to restore a
database on Postgres 9.2.4.
I used pg_dump –Fc with no owner from one server (8.4.2). It’s
working fine for other similar databases.
Hi there,
Did you do the pg_dump usi
On 2014-06-17, 5:33 AM, Khangelani Gama wrote:
Hi
I keep getting the following error when trying to restore a database
on Postgres 9.2.4.
I used pg_dump –Fc with no owner from one server (8.4.2). It’s
working fine for other similar databases.
And then restoring the database on another se
On 13-12-19 11:34 AM, Joseph Kregloh wrote:
Hello,
I am trying to upgrade from 9.0.14 to 9.3. I am using the pg_upgrade
utility. I need to use pg_upgrade because my production database is
800GB+ and with over 80 tablespaces and doing an export from 9.0 and
importing to 9.3 would take at least
On 2013-08-28 2:00 PM, Chrishelring wrote:
Hi all,
I need to let a server access our postgreSQL database but I´m having
problems with the configuration. I´m getting the error message below,
psql: FATAL: no pg_hba.conf entry for host "10.24.17.22", user "k175",
database "k175", SSL off
I´ve ad
On 13-06-21 06:19 PM, Stephen Rasku wrote:
I am trying to write a script that will create and populate a
database. I don't want to enter a password every time so I want to
use a .pgpass file. It has the correct permissions:
$ ls -l $PGPASSFILE
-rw--- 1 Stephen staff 43 21 Jun
On 13-06-19 04:13 PM, karen chau wrote:
Hi Folks,
I'm having trouble with connection / remote connection. I'm running
Postgres on Solaris 10.
$ netstat -a |grep 5432
localhost.5432 *.*0 0 49152 0 LISTEN
6002ae2ee98 stream-ord 6002af1d080 /tmp/.s.PGSQ
