Search Discussions

27 discussions - 132 posts

  • Hey folks, I have postgres server running on ubuntu 12, Intel Xeon 8 CPUs 29 GB RAM. With following settings: max_connections = 550 shared_buffers = 12GB temp_buffers = 8MB max_prepared_transactions ...
    Aug 19, 2013 at 8:07 am
    Aug 25, 2013 at 3:34 pm
  • Hi all, I created a database named "test" with the user "postgres" and I have given all privileges on database "test" to a user that I use daily, called "ssaa". By submitting, as user "ssaa", to ...
    Salvatore BaroneSalvatore Barone
    Aug 23, 2013 at 2:49 pm
    Aug 23, 2013 at 4:04 pm
  • Hi, We run a fairly write-intensive workload and are looking at upgrading our Pg servers. (PostgreSQL 9.1; no practical way to upgrade to 9.2 for a while because we use what's packaged with Debian.) ...
    David F. SkollDavid F. Skoll
    Aug 12, 2013 at 3:28 pm
    Aug 12, 2013 at 11:28 pm
  • Hello, After upgrading postgresql from 9.1.1 to 9.1.9, launching pgadmin3's server status window gives an error dialog box. This is a pgadmin3 client on Windows. The error says ...
    Brian WongBrian Wong
    Aug 5, 2013 at 10:51 pm
    Aug 20, 2013 at 11:36 pm
  • Thanks for your attention. What would you choose for a postgresql installation: 3 disks configured with RAID 0 (in a self replicating SAN) over 10 disks configured with RAID 5 (also in a self ...
    Rene Romero BenavidesRene Romero Benavides
    Aug 27, 2013 at 10:33 pm
    Aug 28, 2013 at 2:36 am
  • Everything you need to see is right here: [root@<serverNameRemoved pg_log]# ls -lrt total 5924 -rw------- 1 postgres postgres 708669 Aug 8 18:59 postgresql-Thu.log -rw------- 1 postgres postgres ...
    Scott WhitneyScott Whitney
    Aug 14, 2013 at 12:27 am
    Aug 16, 2013 at 1:56 pm
  • Hi all, I have some questions about backup on PostgreSQL: 1) pg_dumpall I am sure that this is asked in somewhere: why the pg_dumpall does not support custom or tar format like pg_dump. I have heard ...
    Patrick DungPatrick Dung
    Aug 22, 2013 at 3:53 pm
    Aug 27, 2013 at 7:31 pm
  • Hi there, We're running into a scenario where despite doing a manual vacuum as a superuser the relfrozenxid for one relation now dangerously close to wraparound is not getting reset. It's a Postgres ...
    Armand du PlessisArmand du Plessis
    Aug 5, 2013 at 4:01 pm
    Aug 6, 2013 at 12:25 pm
  • Hi all, I think it is not documented the follow using of replication, but is that correct. 1. Instead of using pg_basebackup for standby DB, i initdb for both standby and primary. 2. Create ...
    Aug 29, 2013 at 1:54 pm
    Aug 30, 2013 at 12:47 pm
  • Hi, We have recently converted our db2 database to PostgreSQL and we stuck on one thing I,e Authentication of users. Let me explain what was in DB2, We have a unix group "mhubrpt" on DB2 unix server ...
    Aug 9, 2013 at 7:49 pm
    Aug 12, 2013 at 6:38 am
  • Dear Team, I have a table with name registers_info with below columns regid character varying, transid bigint, regdate timestamp without time zone, canceldate timestamp without time zone insert into ...
    Technical DoubtsTechnical Doubts
    Aug 31, 2013 at 5:19 am
    Aug 31, 2013 at 5:52 am
  • Dear pgsql-admin, I set up streaming replication using the rsync base backup described in the wiki: http://wiki.postgresql.org/wiki/Binary_Replication_Tutorial However, before starting replication I ...
    Dana ReaDana Rea
    Aug 28, 2013 at 1:50 pm
    Aug 29, 2013 at 7:18 pm
  • Dear Psql Team, Hi there! I have two queries of Postgresql 9.x 1.* What is the number of concurrent users who can access the PostgreSQL 9.x server at a time? Is it necessary for me to go for Postgres ...
    Shyam meghaShyam megha
    Aug 27, 2013 at 6:06 am
    Aug 27, 2013 at 4:25 pm
  • Hey, I am using postgres9.2, on a linux 6.3 box. For start i created a user postgres on linux with login permission and no password. Is it necessary for the postgres user to have login permissions? ...
    Prakhar jauhariPrakhar jauhari
    Aug 27, 2013 at 7:58 am
    Aug 27, 2013 at 8:33 am
  • Hi admins I'm a newbie, I hope this is the right group and admit I have little postgres experience. I'm working on a VM I can easily re-install so killing it doesn't matter. The dir is full of 508 ...
    Ed TarentoEd Tarento
    Aug 26, 2013 at 3:10 am
    Aug 26, 2013 at 8:45 am
  • Hi! I'm reading this article http://www.postgresql.org/docs/current/static/continuous-archiving.htm In section 'Making a Base Backup Using the Low Level API' is said that once one has WAL archiving ...
    Sergey ArlashinSergey Arlashin
    Aug 21, 2013 at 5:35 pm
    Aug 21, 2013 at 6:53 pm
  • Hi all, I have a few questions related to recovering from a near-miss with transactionid wraparound. I'm currently running a vacuum freeze in single user mode on our largest database (about 36 TB) ...
    Natalie WenzNatalie Wenz
    Aug 12, 2013 at 11:39 pm
    Aug 14, 2013 at 2:52 pm
  • Hi, I have 2GB backup of WAL archive folder but the backup of postgres database cluster directory is lost. However I need to restore any data possible from these WAL logs. Is that possible? What do I ...
    Sergey ArlashinSergey Arlashin
    Aug 9, 2013 at 11:07 am
    Aug 9, 2013 at 2:58 pm
  • At a particular time, when an analyse is run on a database, we are uploading a bulk data from excel sheet. Will the analyse slows down the writes performed at that time? Regards Rajagopalan. RR ...
    Rajagopalan RamanujamRajagopalan Ramanujam
    Aug 28, 2013 at 2:49 pm
    Aug 29, 2013 at 11:27 am
  • I'm getting a "Out of memory" error on a 9.1.9 server. What do these lines in the log mean? ~ Brian TopMemoryContext: 738160 total in 82 blocks; 11792 free (52 chunks); 726368 used Type information ...
    Brian WongBrian Wong
    Aug 22, 2013 at 10:54 pm
    Aug 22, 2013 at 11:17 pm
  • Hi -am monitoring the postgresql9.2.4 using monit in my virtual private server. Am always getting following log 2013-08-21 06:02:33 UTC LOG: incomplete startup packet 2013-08-21 06:04:33 UTC LOG ...
    Aug 21, 2013 at 6:12 am
    Aug 21, 2013 at 12:54 pm
  • Hello, I have a table which contains 5 columns the last 3 indicate wether the employer worked with given project or not. The values are simply Yes and No. What I need is a list of people who haven't ...
    Lukasz BrodziakLukasz Brodziak
    Aug 12, 2013 at 7:12 am
    Aug 12, 2013 at 7:15 am
  • Hello, as of now we do a pg_dumpall on most of our PostgreSQL instances. This has some drawbacks when restore of only one of the databases is required, because from what i can see pg_restore is not ...
    Aug 8, 2013 at 8:56 am
    Aug 8, 2013 at 9:24 am
  • I have a primary and secondary running streaming replication with 9.2. Primary posgresql.conf file is slightly different than standby server conf file. If i create the trigger file to force the ...
    Jorge TorralbaJorge Torralba
    Aug 5, 2013 at 5:29 pm
    Aug 6, 2013 at 2:26 am
  • Dear List I am installing software name geo-node, on the way of installation I have some errors with postgresql/postgis and psycopg2 I have also removed and re-install postgresql and python-psycopg2 ...
    Tung ThanhTung Thanh
    Aug 13, 2013 at 10:21 pm
    Aug 13, 2013 at 10:21 pm
  • Hi, I have a problem with my postgresql instance. I don't start service. My server had stopped abrupt because a fs was full . It have a only partition. I think that a postgresql clog file is ...
    Lilian BENOITLilian BENOIT
    Aug 9, 2013 at 5:25 pm
    Aug 9, 2013 at 5:25 pm
  • Hi. I'm looking for suggestions for the best solution to the following situation. I have a database roughly 300 meg with 30 tables. For fieldwork, a copy is running on my mac laptop where I can pull ...
    Paula KirschPaula Kirsch
    Aug 9, 2013 at 4:25 am
    Aug 9, 2013 at 4:25 am
Group Navigation
period‹ prev | Aug 2013 | next ›
Group Overview
grouppgsql-admin @

61 users for August 2013

Albe Laurenz: 12 posts Dzmitry: 9 posts Brian Wong: 6 posts Bricklen: 6 posts Scott Ribe: 6 posts Scott Whitney: 5 posts Tom Lane: 5 posts Bruce Momjian: 4 posts Salvatore Barone: 4 posts Armand du Plessis: 3 posts Arnold, Sandra L.: 3 posts Bocap: 3 posts Christian Ullrich: 3 posts David F. Skoll: 3 posts David Johnston: 3 posts Jan Lentfer: 3 posts Gabriele Bartolini: 2 posts Kevin Grittner: 2 posts Lonni J Friedman: 2 posts Natalie Wenz: 2 posts
show more