Search Results

Search found 41 results on 2 pages for 'pgadmin'.

Page 1/2 | 1 2  | Next Page >

• pgAdmin cannot connect to PostgreSQL 9.1

  - by Nyxynyx

  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 server: could not receive data from server: Software caused connection abortion (0x00002745/10053) postgresql.conf …

  Read the article

• How to install pgAdmin

  - by Kifsif

  I use Ubuntu 12.04 64 bit. At first I installed pgAdmin through Software Center. But it seemed old. So, I decided to uninstal it. Then I downloaded graphic installer for PostgresQL. sudo ./postgresql-9.2.1-1-linux-x64.run I was warned that a previous version of pgAdmin is found, it will be upgraded but I'll…

  Read the article

• Installing pgAdmin III for postgreSQL 9.2

  - by Mikey

  I have a windows server that runs postgresql 9.2. I want to hit it using pgAdmin III from my Ubuntu Linux 12.10 workstation box. I installed pgAdmin III from synaptic and also tried direct download from postgreSQL site using software installer. Regardlesss, I can get only get pgAdmin III for postgresql 9.1.…

  Read the article

• Administer postgres from PGAdmin on remote mac using ssh tunnel

  - by Aidan Ewen

  I've got PostgreSQL installed on a Ubuntu server and I'm trying to connect to that server using PGAdmin on a remote macbook. I've created an ssh tunnel - macbook:~postgres$ ssh -L 5423:localhost:5432 postgres@mydomain.com And I can connect using psql on the macbook as expected - macbook:~ me$ psql -U…

  Read the article

• Searching pgadmin db and grabbing information?

  - by Bootstrotter

  I'm currently trying to write a script in RoR to go into my PGAdmin database and look at a list of users, THEN ignore users that have an image path but look at users who don't have one and then upload a link of a generic photo into their row. My database looks Something like this: id integer | name …

  Read the article

• PostgreSQL 9.1, pgadmin III, Ubuntu 12.04 LTS, support functions

  - by Chaz SLiger

  When pgAdmin III is used to open a PostgreSQL database the following message appears. There does not seem to be any obvious package listed in the Ubuntu Software Center for this. The server lacks instrumentation functions. pgadmin III uses some support functions that are not available by default in all…

  Read the article

• How do I install pgAdmin III for postgreSQL 9.2?

  - by Vector

  I have a Windows server that runs postgresql 9.2. I want to hit it using pgAdmin III from my Ubuntu 12.10 workstation box. I installed pgAdmin III from synaptic and also tried direct download from postgreSQL site using software installer. Regardless, I can get only get pgAdmin III for postgresql 9.1.…

  Read the article

• Exported csv file is not in right lining with pgadmin

  - by user938363

  We exported a pg 9.3 table to csv file in pgadmin. The problem is that from about 10th line, the lining of the columns were messed up and did not line up correctly with the columns above. We tried a few times and every output has the same problem. We follow the instruction on…

  Read the article

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

  - by Serg

  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 apt-get install pgadmin3 Next I focused on setting my username and password in…

  Read the article

• Running SQL script through psql gives syntax errors that don't occur in PgAdmin

  - by Peter

  Hi I have the following script to create a table: -- Create State table. DROP TABLE IF EXISTS "State" CASCADE; CREATE TABLE "State" ( StateID SERIAL PRIMARY KEY NOT NULL, StateName VARCHAR(50) ); It runs fine in the query tool of PgAdmin. But when I try to run it from the…

  Read the article

• export Postgres DB to mdb

  - by Aly

  Hi, 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 pgAdmin 3? Thanks

  Read the article

• could not connect to server: Operation timed out

  - by JohnMerlino

  I am able to ssh into my ubuntu server with a user name and password from the terminal. However, when I try to connect to the server using the same name and password via pgadmin, I am getting the following error: could not connect to server: Operation timed out Is the server…

  Read the article

• pgadmin III doesn't work due to "The server lacks instrumentation functions."

  - by Chaz SLiger

  When pgAdmin III is used to open a PostgreSQL database the following message appears. There does not seem to be any obvious package listed in the Ubuntu Software Center for this. The server lacks instrumentation functions. pgadmin III uses some support functions that…

  Read the article

• can not connect via SSH to a remote Postgresql database

  - by tartox

  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 all all trust host all all …

  Read the article

• PostgreSQL automatic backup

  - by Ragnar123

  I have been trying to set up a backup script on a windows server. I have used pgAgent (scheduling for pgAdmin), to run the backup script. No problems with the backup script. However, my jobs are not running like they should. I have set both the schedule, and the steps. I am…

  Read the article

• PostgreSQL server not showing up in phpPgAdmin

  - by morpheous

  I have installed both phpPgAdmin and pgAdmin III on my Ubuntu 9.10 dev box. I created a server using pgAdmin III, and then added a database and populated it. I then navigated to phpPgAdmin, expecting to be able to see the server and be able to log on to the server using the…

  Read the article

• How do I remove Slony from a restored PostgreSQL database?

  - by Scott Herbert

  I've restored a database which came from a server on which Slony was running. The server on which the database has been restored does not have Slony installed. When the database restored, there were a lot of errors reported, with Slony related objects not getting created due…

  Read the article

• NpgSQL insert file path containing backslashes "\\"

  - by Chau

  I am trying to create a record containing the path to a file. The insertion is done into a Postgres database where UTF8 is enabled, using the NpqSQL driver. My table definition: CREATE TABLE images ( id serial, file_location character varying NOT NULL ) My SQL…

  Read the article

• System blacks out when resuming on opening lid

  - by Ashfaq

  It is happening now and then but frequently these days. My system E420 Lenovo Thinkpad running 12.04 LTS blacks out and doesn't respond when woke up from sleep by opening the lid. I then have to forcibly press the Start button and restart the entire system which is…

  Read the article

• Where is a postgresql 9.1 database stored in ubuntu 12.04?

  - by celenius

  I installed and created a Postgresql database on ubuntu. I then created the database using the following command: sudo su postgres createdb mydatabase However, I can't figure out where the database was initialized. I would like to be able to edit the hba.conf…

  Read the article

• A good database modeling tool for PostgreSQL?

  - by huug

  PostgreSQL comes with the excellent pgAdmin-tool for managing the database but lacks GUI data-modeling utility? I found this list: http://www.databaseanswers.org/modelling_tools.htm but don't have time to evaluate them. Which one do YOU recommend?

  Read the article

• How can I see the numbers of rows a query affects when deleting

  - by Carl Bergquist

  I want to see how many rows my delete query effects so I know its correct. Is this possible using pgadmin?

  Read the article

• SQL: convert backup file from copy format to insert format

  - by takeshin

  I have a PostgreSQL backup made with PHPPgadmin using Export Copy (instead Copy SQL which is actually what I need). File contains entries like this: COPY tablename(id, field) FROM stdin; ... How to convert this file to SQL format? INSERT INTO tablename...…

  Read the article

• Using pg_admin III and PostgreSQL 8.1 (both test and development).

  - by lakshmi

  I want to backup Development and restore it in test and vice-versa. So when I do a backup of the db (in PGAdmin III), it backs it up. But when I restore it, all primary key information is gone and no data is in the tables. Any help would be much appreciated.…

  Read the article

• Postgresql 9.1: ERROR: type "citext" does not exist

  - by gotuskar

  I am trying to execute following query through PgAdmin utility. CREATE TABLE svcr."EventLogs" ("eventId" BIGINT NOT NULL, "eventTime" TIMESTAMP WITH TIME ZONE NOT NULL, "userid" CITEXT, "realmid" CITEXT NOT NULL, "onUserid" CITEXT, "description" TEXT, …

  Read the article

1 2  | Next Page >