1
vote
2answers
27 views

How can I solve these connection-issues with pgadmin?

We have in our local network a server with a Postgres-Installation. Now, as some big inserts (needed days) were running, others had problems connecting via pgadmin. After opening the Server in pgadmin ...
1
vote
1answer
96 views

What is proper host in PGAdmin for accessing postgresql through firewall

Here is my situation. I have Postgresql installed on a Windows Server on a LAN. I have an IIS web server set up outside the lan. I want to connect to the postgresql database from the webserver. ...
0
votes
0answers
357 views

How do I install the Postgresql PLDebugger server extension on Ubuntu 12.04 server?

I have installed the build tools and the postgresql devel packages with: sudo apt-get update & sudo apt -get install build-essential zlib1g-dev libreadline-dev flex bison libssl-dev git-core ...
-1
votes
2answers
384 views

Postgresql pgdump script on RHEL5: “failed: fe_sendauth: no password supplieddatabase ”

What I'm trying to accomplish is having a pg_dump script run as a cron job. Right now I'm just trying to get the script to run by invoking it myself at the command line. I've searched the postgresql ...
0
votes
2answers
2k views

pgAdmin cannot connect to PostgreSQL 9.1

I am trying to use pgAdmin on Windows to connect to postgresql 9.1.8 running on localhost's Ubuntu 12.04 VM. The host's port 5432 forwards to VM's port 5432. pgAdmin Error: Error connecting to the ...
0
votes
0answers
76 views

how to forward pgadmin request via another box with iptables

I have two remote Linux boxes. I can access box1 directly but need to ssh into box2 from box1. What I am trying to accomplish is use iptables to forward request from pgAdmin to box2 via box1. I.e. I ...
0
votes
1answer
776 views

Install pgadmin in debian server [closed]

I have got pgAdminIII-1.14 source code from the official website. Now I'm trying to compile it, on a Debian Squeeze machine. At first I did: ./configure and I got this error: configure: error: ...
1
vote
1answer
1k views

Cannot login to Postgrest database despite setting password for user 'postgres'

I'm trying to use pgAdmin III to manage my Postgres database. Here are the commands I've run on my machine: sudo apt-get install postgresql Then I installed the pgAdmin III application: sudo ...
2
votes
1answer
388 views

Can't connect to PSQL Database on a VM from my Mac

Trying to connect to my PSQL database on my CentOS VM from my Mac using pgAdmin3. Getting the following error: Access to database denied The server doesn't grant access to the database: the server ...
3
votes
4answers
4k views

PostgreSQL service initdb doesn't work

I installed PostgreSQL 9.1.2 on my fedora 16 in a method similar to mentioned here, and tested it, which means that my installation is working fine. But when I do: service postgresql initdb or even ...
0
votes
2answers
1k views

Problems with installing a postgres server on a windows machine

I have tried to install a postgres on my windows Vista, but I cannot seem to get it to work. I download PGAdmin tools and when i try to connect to localhost it tells me the generic thing that the ...
-2
votes
1answer
169 views

Installing PGAdmin 3 [closed]

How can I install pgAdmin3 on RHEL 4? I've install it but I can't access it. After ./configure, I don't know what I should do. I want access to the postgresql with a GUI, because from i don't ...
1
vote
1answer
2k views

Cannot connect to PostgreSQL DB Via pgAdmin

So, I installed a minimal install of Fedora 15 to create a server for a web application. I also installed PostgreSQL 9.1 from pgrpms.org. PostgreSQL install went well. Locally, I was able to initdb, ...
0
votes
0answers
554 views

Postgresql Server doesn't listen

I have installed a new server with Postgresql 9. It works fine locally. When I try to access it remotely using pgAdmin III I get the following error: Server doesn’t listen The server doesn’t ...
0
votes
2answers
163 views

Which database user do you use to connect to pgAdmin3? (PostgreSQL9/CentOS6)

I've installed pgAdmin3 in my CentOS6. I am using PostgreSQL9. My problem is that I'm not able to add a server to the pgAdmin3. It gives me an error: I have not a password for the user ...
1
vote
1answer
275 views

SQL Server DBA moving to Greenplum / Postgres on Linux ( Centos ) looking for friendly MS Sql Agent like scheduler instead of CRON

To be honest, I and others are spoiled by Microsoft's SQL Agent. We'd really like to keep properties of SQL Agent : the features, the usable GUI. I searched serverfault for an evaluation of ...
4
votes
1answer
1k views

Ident Authentication with pgAdmin III

Is there a way to get pgadmin to do ident auth for local users? It would be nice to not have to set a password for my local user on a development machine and simply be able to use psql and pgadmin3 ...
2
votes
3answers
2k views

can not connect via SSH to a remote Postgresql database

I am trying to connect via pgAdmin3 GUI to a Postgresql database on a remote server myHost on port 5432. Server side : I have a Unix myUser that match a postgresql role. pg_hba.conf is : local ...
0
votes
2answers
544 views

export Postgres DB to mdb

I have a few DB's which I can access through pgAdmin 3, I have a piece of software that can only analyze .mdb files. does anyone know how to convert/export a postgres db to a mdb? preferably through ...
0
votes
1answer
758 views

PostgreSQL copy permissions

I'm using pgadmin to copy a csv file into the database. this worked fine a million times until today. I get the following error Could not open file "/path.csv" for reading: permission denied I ...