FAQ

Search Discussions

29 discussions - 93 posts

  • Hi Everyone, So we had to failover and do a full base backup to get our slave database back online and ran into a interesting scenario. After copying the data directory, setting up the recovery.conf, ...
    Phil MonroePhil Monroe
    Jan 12, 2013 at 2:32 am
    Jan 15, 2013 at 7:54 pm
  • Hi, I made some changes to postgresql.conf and I want them to take effect without having to restart the server. I tried select pg_reload_conf(); /usr/pgsql-9.1/bin/pg_ctl reload but when I do 'show ...
    Jose MartinezJose Martinez
    Jan 3, 2013 at 4:25 pm
    Jan 4, 2013 at 2:26 pm
  • I have a situation where pg_xlog started growing until it filled up the disk drive. I got alerted to the error and started investigating. Checked the logs and I am seeing the following entry ...
    Benjamin KrajmalnikBenjamin Krajmalnik
    Jan 7, 2013 at 9:22 pm
    Jan 8, 2013 at 2:31 am
  • Hi This is postgreSQL 9.2.1 By accident I was running the the following command «delete from org_oks.oks_kartobjekt_flate where id = 53» on the wrong database. - I first picked up last basebackup ...
    Lars Aksel OpsahlLars Aksel Opsahl
    Jan 5, 2013 at 9:30 pm
    Jan 13, 2013 at 1:31 pm
  • Hi, Can we dump data from any postrgres version and restore it to any version of postgres ? If not , can anyone tell which version of data is compatible to which version ? Rgrds Suhas.B -- View this ...
    Suhas.basavaraj12Suhas.basavaraj12
    Jan 9, 2013 at 11:48 am
    Jan 11, 2013 at 10:58 pm
  • Hi all, I am running custom applications on a Linux platform which essentially have Perl and Postgres as prerequisites. In the past, we used an arcane Linux distro which left me with no other option ...
    Armin ReschArmin Resch
    Jan 7, 2013 at 6:17 pm
    Jan 11, 2013 at 3:34 pm
  • Hi: I'm relatively new to postgres: I've to alter a column which is of datatype bytea to varchar(255). I used this: ALTER TABLE tablename ALTER COLUMN columname TYPE varchar(255); But I'm really not ...
    Rajagopalan, JayashreeRajagopalan, Jayashree
    Jan 15, 2013 at 5:12 am
    Jan 15, 2013 at 3:58 pm
  • I have a postgresql 9.1 in my server,And here 's my query,It costs 944,319.072 ms,it is so slow,query result have 27 records. SELECT ...
    JeromeJerome
    Jan 4, 2013 at 6:01 am
    Jan 4, 2013 at 3:58 pm
  • Greetings, Are there any compile options I should use when compiling(configure) posgresql-9.1.7 from source on a new centos 6.3 box? Just wondering what different gcc compile options are used in the ...
    Dx k9Dx k9
    Jan 17, 2013 at 4:39 pm
    Jan 17, 2013 at 5:54 pm
  • Hi, EXPLAIN on table which was recently analyzed by the autovacuum process : explain delete from agg_t1343_incoming_a3_src_net_and_dst_net_f5 where start_date < 1353317127200; QUERY PLAN ...
    Baptiste LHOSTEBaptiste LHOSTE
    Jan 3, 2013 at 10:26 am
    Jan 17, 2013 at 11:31 am
  • Yesyerday I had an issue where Postgres could not write to a fsm file and started creating WAL files until it filled up the disk space on the partition where the WAL files were located and panicked ...
    Benjamin KrajmalnikBenjamin Krajmalnik
    Jan 9, 2013 at 1:55 am
    Jan 9, 2013 at 3:27 am
  • So I've been digging through a database on an embedded device for two days trying to figure out which table some data is stored in. There are litterally 1000 tables in the database and I haven't come ...
    Greg SchenzelGreg Schenzel
    Jan 4, 2013 at 6:09 pm
    Jan 7, 2013 at 4:01 pm
  • Stupid person here. Just got PostgresSQL today. Have text dump file. Need to restore. I think I need to use psql, but do not even know how to get to it. Need exact instructions on where to enter the ...
    J RouseJ Rouse
    Jan 5, 2013 at 8:54 pm
    Jan 7, 2013 at 1:11 pm
  • Hello, I have running postgresql maste-slave replication with activated archiving-mode on the master. Question: is it safe to clean older archived logs or it may corrupt the slave replication ? And ...
    ViktorViktor
    Jan 3, 2013 at 1:15 pm
    Jan 3, 2013 at 3:21 pm
  • I have 2 servers which are using streaming replication (pg 9.0.4). The secondary server is there primarily as a disaster recovery server, but we are also using it for reporting, so as not to place ...
    Benjamin KrajmalnikBenjamin Krajmalnik
    Jan 17, 2013 at 5:49 pm
    Jan 17, 2013 at 11:32 pm
  • Does anyone know if one of the signals below can be sent to break out ,of this state *without* the postmaster sensing a crashed backend? I've seen several times in the past at other companies, ...
    Jerry SieversJerry Sievers
    Jan 17, 2013 at 8:36 pm
    Jan 17, 2013 at 9:38 pm
  • Hi Team, We need to implement incremental backup (PITR) in our environment, since our production database is in high risk. We are running with PostgreSQL 9.1 We need to implement this on both ...
    Vinod VVinod V
    Jan 15, 2013 at 6:23 am
    Jan 17, 2013 at 9:38 pm
  • I've got replication setup (streaming replication) between two 9.2.2 clusters. Everything went just fine on that, and it's working as expected. Now, obviously, I'll know if my primary goes down. I ...
    Scott WhitneyScott Whitney
    Jan 17, 2013 at 4:20 pm
    Jan 17, 2013 at 5:35 pm
  • Greetings, I'm running postgres-9.2.2 in a Linux-x86_64 cluster with 1 master and several hot standby servers. Since upgrading to 9.2.2 from 9.1.x a few months ago, I switched from generating a base ...
    Lonni J FriedmanLonni J Friedman
    Jan 9, 2013 at 6:28 pm
    Jan 15, 2013 at 10:57 am
  • PGJyPkkgaGF2ZSBjcmVhdGVkIGEgdXNlcih1c2VyMSksIGFuZCB3aXRoIHRoaXMgdXNlciBJ IGNyZWF0ZWQgYSBkYjEgYW5kIHNvbWUgdGFibGVzLCBzb21lIGZ1bmN0aW9ucyBpbiBpdC48 ...
    戴松晚戴松晚
    Jan 8, 2013 at 2:15 am
    Jan 14, 2013 at 5:43 pm
  • Hello- I have a large Postgres database on Ubuntu 12 (+100GB). I have an old, SATA-based, spinning drive and a new SSD drive. I mainly do data analysis on Postgres (big, ugly select statements). I ...
    Postgresql OrgPostgresql Org
    Jan 5, 2013 at 3:31 am
    Jan 14, 2013 at 5:38 pm
  • PostgreSQL 9.2.2 Is there a configuration parameter in PostgreSQL that will allow a full query to be displayed in the log file? What I see: UPDATE abc.table set def=$1 WHERE id=$2 What I want to ...
    Campbell, LanceCampbell, Lance
    Jan 8, 2013 at 3:50 pm
    Jan 8, 2013 at 4:29 pm
  • Hi all; I'm building 9.2.2 from source on a Scientific Linux 6.2 box. I downloaded the tar.bz2 file from here: http://www.postgresql.org/ftp/source/v9.2.2/ I unzipped the file and ran this ...
    CS DBACS DBA
    Jan 5, 2013 at 5:58 pm
    Jan 5, 2013 at 6:00 pm
  • I have been experiencing spooky behavior with Postgres after using the Mac installer for Postgres. There seems to be an existing half-baked Postgres installation that was already there and remains ...
    Jonathan HaywardJonathan Hayward
    Jan 4, 2013 at 6:56 pm
    Jan 4, 2013 at 7:54 pm
  • Postgres gentlemen good day, my question is very timely, I need to migrate a system from Informix, PostgreSQL, what are the advantages Postgres, and is there any tool to perform this migration? ...
    Alcívar ArcosAlcívar Arcos
    Jan 3, 2013 at 4:24 pm
    Jan 3, 2013 at 6:38 pm
  • Hi, How can i get the listed columns which mentioned in a update command in a trigger ? Thanks And Regards. wang
    WangxvwangWangxvwang
    Jan 9, 2013 at 4:50 am
    Jan 9, 2013 at 4:50 am
  • Restarting the postmaster recreated the missing fsm file. Recovery completed and database is back up.
    Benjamin KrajmalnikBenjamin Krajmalnik
    Jan 8, 2013 at 12:04 am
    Jan 8, 2013 at 12:04 am
  • PostgreSQL 9.2.2 I am using the above PostgreSQL. When in pgAdmin III (1.16) and I use the "Server Status" I will see things like: UPDATE abc.table set def=$1 WHERE id=$2 How can I get this to ...
    Campbell, LanceCampbell, Lance
    Jan 3, 2013 at 3:17 pm
    Jan 3, 2013 at 3:17 pm
  • Hi. This is a collection of very basic monitoring sql statements returning one numerical value. We switched from nagios to prtg network monitoring. I had to reformulate the monitoring statements, ...
    YnuxYnux
    Jan 2, 2013 at 2:50 pm
    Jan 2, 2013 at 2:50 pm
Group Navigation
period‹ prev | Jan 2013 | next ›
Group Overview
grouppgsql-admin @
categoriespostgresql
discussions29
posts93
users47
websitepostgresql.org
irc#postgresql

47 users for January 2013

Benjamin Krajmalnik: 8 posts Tom Lane: 8 posts Albe Laurenz: 4 posts Kevin Grittner: 4 posts Phil Monroe: 4 posts Armin Resch: 3 posts Casey Allen Shobe: 3 posts CS DBA: 3 posts Lars Aksel Opsahl: 3 posts Magnus Hagander: 3 posts Walter Hurry: 3 posts Aaron Bono: 2 posts Baptiste LHOSTE: 2 posts Campbell, Lance: 2 posts Greg Schenzel: 2 posts Heikki Linnakangas: 2 posts Jerome: 2 posts Jerry Sievers: 2 posts Jov: 2 posts Lonni J Friedman: 2 posts
show more
Archives