Search Results

Search found 624 results on 25 pages for 'postgres'.

Page 1/25 | 1 2 3 4 5 6 7 8 9 10 11 12  | Next Page >

• Postmaster uses excessive CPU and Disk Writes

  - by wolfcastle

  using PostgreSQL 9.1.2 I'm seeing excessive CPU usage and large amounts of writes to disk from postmaster tasks. This happens even while my application is doing almost nothing (10s of inserts per MINUTE). There are a reasonable number of connections open however. I've been trying to determine what in my application is causing this. I'm pretty…

  Read the article

• How to set the SPN for Postgres SSPI

  - by chotchki

  I am trying to setup Postgres to support SSPI/Kerberos, however I think that I have not found out what the correct SPN that is needed to get it working. The background details: Service account for postgres: 'postgres' Domain Name: 'testdomain.com' Domain Controller: 'dc.testdomain.com' I have tried the following SPNs and have had zero…

  Read the article

• Pgagent startup script (under the postgres user)

  - by Dominique Guardiola

  Hello, I'm trying to make a clean startup script for pgagent I found one here but I don't see how I can change this : if start-stop-daemon --start --quiet --pidfile /var/run/pgagent.pid \ --exec /usr/bin/pgagent "hostaddr=127.0.0.1 dbname=postgres user=postgres \ password=XXXXXXX";then to launch something like this : su - postgres -c…

  Read the article

• Postgres backup

  - by Abbass

  Hello, I have a Bacula script that does an automatic backup of a Postgres Database. The script makes two backups using (pg_dump) of the data base : The schema only and the data only. /usr/bin/pg_dump --format=c -s $dbname --file=$DUMPDIR/$dbname.schema.dump /usr/bin/pg_dump --format=c -a $dbname --file=$DUMPDIR/$dbname.data.dump The…

  Read the article

• Connect to Postgres remotely, open port 5432 for Postgres in iptables

  - by Victor

  I am trying to connect to Postgres remotely but I need to open port 5432 in iptables. My current iptables configuration is as follows: *filter # Allows all loopback (lo0) traffic and drop all traffic to 127/8 that doesn't use lo0 -A INPUT -i lo -j ACCEPT -A INPUT ! -i lo -d 127.0.0.0/8 -j REJECT # Accepts all established inbound…

  Read the article

• How do you find the disk size of a Postgres / PostgreSQL table and its indexes

  - by mmrobins

  I'm coming to Postgres from Oracle and looking for a way to find the table and index size in terms of bytes/MB/GB/etc, or even better the size for all tables. In Oracle I had a nasty long query that looked at user_lobs and user_segments to give back an answer. I assume in Postgres there's something I can use in the information_schema…

  Read the article

• Postgres createuser.exe silent execution from batch script

  - by Woot4Moo

  I am finding myself with the issue of needing to execute the postgres createuser.exe from a batch script and cannot get it to stop prompting me with the following: Enter name of role to add: my batch script looks like this: echo calling createuser! createuser username %super_user% -s -U Super_Postgres s -q Where %super_user% is a…

  Read the article

• How do you find the disk size of a Postgres table and its indexes

  - by mmrobins

  I'm coming to Postgres from Oracle and looking for a way to find the table and index size in terms of bytes/MB/GB/etc, or even better the size for all tables. In Oracle I had a nasty long query that looked at user_lobs and user_segments to give back an answer. I assume in Postgres there's something I can use in the…

  Read the article

• How do you find the row count for all your tables in Postgres

  - by mmrobins

  I'm looking for a way to find the row count for all my tables in Postgres. I know I can do this one table at a time with a select count(*) from table_name; but I'd like to see the row count for all the tables and the order by that to get an idea of how big all my tables are.

  Read the article

• How to restart postgres on OS X?

  - by Scott Semple

  After a reboot, postgres on my machine hasn't restarted. What command should I use in Terminal to get it going again?

  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 order to login: sudo -u postgres psql…

  Read the article

• Cannot connect to postgres installed on Ubuntu

  - by Assaf

  I installed the Bitnami Django stack which included PostgreSQL 8.4. When I run psql -U postgres I get the following error: psql: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"? PG is…

  Read the article

• postgres - ERROR: syntax error at or near "COST"

  - by cino21122

  EDIT Taking COST 100 out made the command go through, however, I'm still unable to run my query because it yields this error: ERROR: function group_concat(character) does not exist HINT: No function matches the given name and argument types. You may need to add explicit type casts. The query I'm running is…

  Read the article

• Good Postgres graphical client for Windows

  - by alex

  The name pretty much says it all. Right now I'm using Squirrel - it crashes frequently and suffers from memory problems (I've tried increasing the heap size). I don't need anything particularly fancy or full-featured - just something that won't take up 2.4 GB of RAM to store a 1.5 million line, 8 column…

  Read the article

• postgres - ERROR: operator does not exist

  - by cino21122

  Again, I have a function that works fine locally, but moving it online yields a big fat error... Taking a cue from a response in which someone had pointed out the number of arguments I was passing wasn't accurate, I double-checked in this situation to be certain that I am passing 5 arguments to the…

  Read the article

• Postgres 8.4 stackbuilder not run in Ubuntu12.04

  - by vikas

  I have installed Postgres 8.4 in my Ubuntu 12.04 , but after installation it does not run stackbuilder.It also not running from menu bar . How can i run stackbuilder ? edit:I install this from postgres-8.4.run package.It uses a GUI interface.After installing postgres it should run stackbuilder…

  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:~…

  Read the article

• Why doens't my Postgres user have permissions to add a Postgres database?

  - by orokusaki

  First, I ran: sudo su postgres createuser -U postgres foouser -P which worked fine, and I ran: createdb -U foouser -E utf8 -O foouser foodatabase -T template0 and got "permission denied: cannot create database" Firstly, should I even su as postgres to do operations like the first one…

  Read the article

• Locate a user's bashrc file

  - by Starkers

  Really confused. Upon running cat etc/passwd I have found this: postgres:x:117:126:PostgreSQL administrator,,,:/var/lib/postgresql:/bin/bash meaning I have a postgres user, right? I want to change the bashrc environment file of this user to make commands available to it. …

  Read the article

• "No version information available" - After installing Postgres

  - by intellidiot

  I have installed Postgres 9.1.4 on an Ubuntu 12.04 (precise) 64-bit from here http://www.openscg.com/se/postgresql/packages.jsp, but right after installing many commands (programs) are throwing these following warnings in different combinations: …

  Read the article

• PostGres Error When Using Distinct : postgres ERROR: could not identify an ordering operator for ty

  - by CaffeineIV

  ** EDIT ** Nevermind, just needed to take out the parens... I get this error: ERROR: could not identify an ordering operator for type record when trying to use DISTINCT Here's the query: select DISTINCT(g.fielda, g.fieldb, r.type) from…

  Read the article

• What schema documentation tools exist for PostgreSQL

  - by Brad Koch

  MySQL has MySQL Workbench for designing and documenting your schema, and generates CREATE and ALTER scripts based on your design. We're looking at migrating to PostgreSQL in the near future, and we do need a practical way of documenting and…

  Read the article

• How to reset the postgres super user password on mac os x

  - by Andrew Barinov

  I installed postgres on my mac running 10.6.8 and I would like to reset the password for the postgres user (I believe this is the super user password) and then restart it. All the directions I found do not work because I think my user name…

  Read the article

• Cannot start Postgres daemon after installing with Yum

  - by Sean the Bean

  I was trying to install Postgres 9.1.4 on Fedora 17 using Yum. If I do: sudo yum install postgres-libs sudo yum install postgres sudo yum install postgis All the installs appear to complete successfully (i.e., no errors), but I cannot…

  Read the article

• How do I install Postgres Graphical Installer?

  - by Tusar Das

  I am a newbie in using Ubuntu (more precisely never used linux except the production deployment ). Now I choose to hold a grip on the system and intalled a latest 11.10 Ubuntu in my 32 bit Intel** desktop. In this machine **I have a…

  Read the article

1 2 3 4 5 6 7 8 9 10 11 12  | Next Page >