FAQ

Search Discussions

40 discussions - 176 posts

  • Hi list, I am running Postgres 9.1 on Ubuntu 12.04. I have a dedicated disk for pg_xlog, using ext4 filesystem with journaling in writeback mode During high load times, the disk usage is arround ...
    German BeckerGerman Becker
    Jul 26, 2013 at 7:21 pm
    Jul 31, 2013 at 6:10 pm
  • I have 9.1 running on 5432, and 9.2 running on 5433. The 9.1 database size is 153g. 9.1 is actively used by systems, 9.2 is just sitting there empty. I'd like to move the 9.1 database to 9.2 without ...
    Wells OliverWells Oliver
    Jul 10, 2013 at 5:53 pm
    Jul 10, 2013 at 9:11 pm
  • I've installed postgres 9.2 on a server, call it db01. I now want to access postgres from my app server, call it app01. What do I install on the app01 server? I've installed postgres 9.2 on it and ...
    Struckhoff, KevinStruckhoff, Kevin
    Jul 10, 2013 at 9:58 pm
    Jul 11, 2013 at 3:37 am
  • Hello all you guys, I've sent the same problem in performance list. Some answered me, but didn't resolved the situation. Since 2 weeks I'm get stucked in a very strange situation: from time to time ...
    Rafael DomicianoRafael Domiciano
    Jul 15, 2013 at 1:16 pm
    Jul 16, 2013 at 6:00 pm
  • All: it would take ~4 hours to pg_restore a backup. I want to quickly create a duplicate cluster (for testing). My idea: 1. pg_ctlcreatecluster 9.1 test 2. rm /var/lib/postgresql/9.1/test/* 2. cp ...
    Wells OliverWells Oliver
    Jul 11, 2013 at 8:31 pm
    Jul 15, 2013 at 5:36 am
  • Hi, I have various DB in my DB cluster, i want to vacuum all DB's using a shell script...... scheduling via cron. It would be a great help if anyone could provide me a Shell Script to vacuum all DB's ...
    Manish KediyalManish Kediyal
    Jul 29, 2013 at 7:17 am
    Jul 30, 2013 at 4:41 am
  • Admins; Planning to pg_upgrade some large (3TB) clusters using hard link method. Run time for the upgrade itself takes around 5 minutes. Nice!! Origin version 8.4 and destination version 9.1 ...
    Jerry SieversJerry Sievers
    Jul 8, 2013 at 7:21 pm
    Jul 23, 2013 at 11:48 pm
  • Does anyone any tool in command line for comparison schema/data?
    Javier Urbano ContrerasJavier Urbano Contreras
    Jul 17, 2013 at 3:00 pm
    Jul 18, 2013 at 4:20 pm
  • Hello People, I need some clarification on Continuous Archiving and Point-In-Time Recovery (PITR). I have been able to replicate a postgresql 8.4 database from one machine to another using rsync and ...
    Nestor A. DiazNestor A. Diaz
    Jul 15, 2013 at 10:06 pm
    Jul 18, 2013 at 1:20 pm
  • Can a single Postgres database contain more than 20,000 schemas? What are the implications of such a database design. I was reading about postgres schemas here - ...
    Anand MuthukrishnanAnand Muthukrishnan
    Jul 24, 2013 at 11:11 am
    Jul 24, 2013 at 6:17 pm
  • I have this error in a pg_upgrade: psql:pg_upgrade_dump_db.sql:88725: ERROR: UNION could not convert type text[] to integer[] Command executed: time \ /usr/lib/postgresql/9.2/bin/pg_upgrade -k \ -b ...
    Wells OliverWells Oliver
    Jul 12, 2013 at 4:55 am
    Jul 15, 2013 at 4:53 pm
  • https://wiki.postgresql.org/wiki/Unindexed_foreign_keys Suggestions and feedback welcome on the query referenced in the link above.
    BricklenBricklen
    Jul 7, 2013 at 11:29 pm
    Jul 10, 2013 at 12:36 am
  • I’ve noticed a weird situation on one of our development servers running PostgreSQL 9.1.3 where roles have been dropped even though objects depend on that user. I didn’t think that was possible due ...
    Wojciechowski, Robert (GE Transportation)Wojciechowski, Robert (GE Transportation)
    Jul 1, 2013 at 2:20 pm
    Jul 1, 2013 at 7:40 pm
  • Hello, it seems ( for quite some time now ) that PostgreSQL is using the -c option of iconv when exporting data to a different encoding ...
    Jan-Peter SeifertJan-Peter Seifert
    Jul 15, 2013 at 2:55 pm
    Jul 22, 2013 at 11:53 am
  • I ran: pg_ctlcluster 9.1 main start Received: The PostgreSQL server failed to start. Please check the log output. But, hey, in /var/log/postgresql, there was absolutely no logging. Nothing. After ...
    Wells OliverWells Oliver
    Jul 12, 2013 at 2:07 am
    Jul 12, 2013 at 6:15 pm
  • I was recently asked how long it takes for postgres (or in my case pgbouncer) to create a database connection and could not find a way within postgres logging or psql to report this information. I ...
    Mike BroersMike Broers
    Jul 12, 2013 at 3:00 pm
    Jul 12, 2013 at 4:03 pm
  • I have 9.1 and 9.2 installed, and I am trying to build the PLR extension: http://www.joeconway.com/plr/doc/plr-install.html I'm using the USE_PGXS=1 method. But it's building for 9.1: gcc ... ...
    Wells OliverWells Oliver
    Jul 11, 2013 at 5:44 pm
    Jul 11, 2013 at 6:35 pm
  • Hallo, between pg_dumpall alldb.sql (store) and psql -f alldb.sql postgres (restore) is it necessary to drop existing objects (for example roles, ...) ? Any help is appreciated.
    Asmus ReinhardAsmus Reinhard
    Jul 29, 2013 at 1:19 pm
    Jul 31, 2013 at 7:00 am
  • Hello, I am planning to upgrade our databases from 9.0.4 to 9.1.3 and I found a problem while upgrading one database that has many tablespaces. The upgrade fails with the following error "Cannot ...
    Mónica GamarraMónica Gamarra
    Jul 15, 2013 at 5:54 pm
    Jul 16, 2013 at 10:45 pm
  • Following up to my earlier post: I have a master and a slave server (using WAL), both 9.1. My 9.2 upgrade process is: 1) stop postgres on both servers 2) run pg_upgrade --link on both servers 3) ...
    Wells OliverWells Oliver
    Jul 10, 2013 at 9:14 pm
    Jul 16, 2013 at 9:59 am
  • I have a master and a slave running streaming replication between the two servers. I would like to setup some kind of third machine to play the role of observer node to monitor the replication and do ...
    Jorge TorralbaJorge Torralba
    Jul 15, 2013 at 3:55 pm
    Jul 15, 2013 at 4:38 pm
  • Hello, I was just wondering: Is it possible to restore a specific table from an online backup? Or is it only possible if we first restore the backup, replay all the logs, and then take the table ...
    BertBert
    Jul 15, 2013 at 1:02 pm
    Jul 15, 2013 at 1:35 pm
  • Hello! We are running 8.4.13 on this particular database and recently we have been getting empty two phase commit state files inside the pg_twophase directory. These prepared transactions can't be ...
    Vincent LauVincent Lau
    Jul 13, 2013 at 11:41 pm
    Jul 14, 2013 at 9:04 pm
  • Hello, I made a bad update to search_path, which basically had line returns: prod_candidate=# alter user postgres set search_path to 'search_path=public, schemprod_candidate'# a1, schema2, ...
    Colin SColin S
    Jul 8, 2013 at 12:40 pm
    Jul 8, 2013 at 12:57 pm
  • Hello All, I am very new to postgres and this is my first post to the community, so please forgive my ignorance if any. I am trying to achieve a circular replication with postgres; meaning two ...
    Jayesh NambiarJayesh Nambiar
    Jul 5, 2013 at 6:59 am
    Jul 6, 2013 at 5:34 am
  • Hi All, I have a 8.4 server and I'd like to use --section parameter of pg_dump and pg_restore, which is available only in 9.2. 1. Is it, in general, safe to use 9.2 tools on 8.4 server? AFAIK the ...
    Jiří HlinkaJiří Hlinka
    Jul 3, 2013 at 8:33 am
    Jul 3, 2013 at 8:51 pm
  • Hi, I have a doubt about stats reset. I've been investigating some zero values in some tables tuples stats. By querying pg_stat_database view I can see reset times (pg_stat_database) that have not ...
    LuisLuis
    Jul 26, 2013 at 3:31 pm
    Jul 27, 2013 at 6:35 am
  • I am currently getting a "unexpected EOF on client connection" when running pg_dumpall from a bash shell script in cron. I have looked online to see if anyone else is having or have had this problem ...
    Arnold, Sandra L.Arnold, Sandra L.
    Jul 23, 2013 at 5:52 pm
    Jul 23, 2013 at 11:29 pm
  • Hi all, I am currently using postgresql 9.2 installation. While taking base backups using pg_basebackup utility, I noticed that permissions of the directory which i specify for base backup are set to ...
    Prakhar jauhariPrakhar jauhari
    Jul 16, 2013 at 4:42 am
    Jul 16, 2013 at 8:39 am
  • Hi, is it possible to start psql in interactive mode without connecting to a database (similar to "sqlplus /nolog" for Oracle databases)? From research I think it's not possible but I might have ...
    Thorsten KampeThorsten Kampe
    Jul 7, 2013 at 8:20 am
    Jul 7, 2013 at 12:26 pm
  • Good Day All I setup my postgres servers to allow certificate authentication. Right now I have two database servers and one application server. Users are only allowed to connect into the application ...
    MeganMegan
    Jul 1, 2013 at 5:03 pm
    Jul 1, 2013 at 5:16 pm
  • Hi all, I am on a Debian wheezy system with postgresql 9.1 installed. I have a hot standby configuration with the standby server doing the job of taking backups of the database. For this purpose I ...
    Jürgen FuchsbergerJürgen Fuchsberger
    Jul 31, 2013 at 1:16 pm
    Jul 31, 2013 at 1:16 pm
  • Last days i'm looking tot he options of pg_dumpall and I think the answer of my question is using option -c. Using this option pg_dumpall generates at first drop commands for existing objects ...
    Asmus ReinhardAsmus Reinhard
    Jul 31, 2013 at 7:14 am
    Jul 31, 2013 at 7:14 am
  • Hi, I have a Windows box running Windows Server 2003 Enterprise Edition Service Pack 2 with PostgreSQL 8.2.23 and getting a server crash while trying to select a table: select * from "TOTALL.tt_est" ...
    Carlos Henrique ReimerCarlos Henrique Reimer
    Jul 31, 2013 at 1:11 am
    Jul 31, 2013 at 1:11 am
  • Hi All; A client's master database crashed, they tried to startup the streaming replication slave and it refuses to start. See the log details below... thanks in advance for any help Master log ...
    CS DBACS DBA
    Jul 30, 2013 at 11:19 pm
    Jul 30, 2013 at 11:19 pm
  • Hello, yesterday, in the process of bloat control, our maintenance script decided to do a vacuum full on a table, because there was more than 50% free space / dead records due to a massive update ...
    BertBert
    Jul 29, 2013 at 7:08 am
    Jul 29, 2013 at 7:08 am
  • 0

    Fw:

    http://mbmwebdesign.com/cnn.com.today.html?z2v5s2b1e9x3y0v6w6k6a7
    Lucas Restrepo gilLucas Restrepo gil
    Jul 22, 2013 at 3:45 pm
    Jul 22, 2013 at 3:45 pm
  • http://macelleriafreni.it/mv/hki.bsdnumcq Mag Gam 7/21/2013 7:23:54 AM
    Mag GamMag Gam
    Jul 21, 2013 at 6:24 am
    Jul 21, 2013 at 6:24 am
  • Hello People, In reference to my last post <http://www.postgresql.org/message-id/51E4725C.3050609@tiendalinux.com , my question is: It is possible to recover more (subsequent) WAL files when I have ...
    Nestor A. DiazNestor A. Diaz
    Jul 16, 2013 at 4:31 pm
    Jul 16, 2013 at 4:31 pm
  • i 'M USING GEONETWORK SOFTWARE, IN WHICH BACKEND-DATABASE IS NI POSTGRESQL 8.4. ACCIDENTALLY SYSTEM ADMIN ADD SYSTEM SERVER TO DO DOMAIN, WHICH MAKES SOME OF THE CHANGES TO THE SERVER, SO LONG AS ...
    Emmanuel MassaweEmmanuel Massawe
    Jul 16, 2013 at 12:37 pm
    Jul 16, 2013 at 12:37 pm
Group Navigation
period‹ prev | Jul 2013 | next ›
Group Overview
grouppgsql-admin @
categoriespostgresql
discussions40
posts176
users67
websitepostgresql.org
irc#postgresql

67 users for July 2013

Wells Oliver: 13 posts German Becker: 9 posts Bricklen: 8 posts Alvaro Herrera: 7 posts Bruce Momjian: 7 posts Raghu ram: 7 posts Kevin Grittner: 6 posts Sergey Konoplev: 6 posts Vincent Lau: 6 posts Gilberto Castillo: 5 posts Scott Ribe: 5 posts Struckhoff, Kevin: 5 posts Jerry Sievers: 4 posts Ktm: 4 posts Manish Kediyal: 4 posts Nestor A. Diaz: 4 posts Javmendez1: 3 posts Marcos Cano: 3 posts Peter Eisentraut: 3 posts Prashanth Ranjalkar: 3 posts
show more
Archives