FAQ

PostgreSQL > pgsql-admin

Search Discussions

12,571 discussions - 43,441 posts

  • 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
  • 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 ...
    BocapBocap
    Aug 29, 2013 at 1:54 pm
    Aug 30, 2013 at 12:47 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
  • 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
  • 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
  • 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
  • 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
  • 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 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
  • 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 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! 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 -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 ...
    AlfredAlfred
    Aug 21, 2013 at 6:12 am
    Aug 21, 2013 at 12:54 pm
  • 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 ...
    DzmitryDzmitry
    Aug 19, 2013 at 8:07 am
    Aug 25, 2013 at 3:34 pm
  • 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
  • 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 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, 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, 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
  • 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 ...
    RamanajvvRamanajvv
    Aug 9, 2013 at 7:49 pm
    Aug 12, 2013 at 6:38 am
  • 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 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
  • 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
  • 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 ...
    Lst_hoe02Lst_hoe02
    Aug 8, 2013 at 8:56 am
    Aug 8, 2013 at 9:24 am
  • 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
  • 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
  • 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 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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 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
    Aug 5, 2013 at 1:40 pm
  • 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
  • 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, In reference to my last post <http://www.postgresql.org/message-id/[email protected] , 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
    Aug 10, 2013 at 2:06 am
  • 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
  • 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
  • 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
  • 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
  • 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, 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
  • 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
  • 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
Latest
Group Navigation
period‹ prev | Latest | first ›
Group Overview
grouppgsql-admin @
categoriespostgresql
discussions12,571
posts43,441
users7,305
websitepostgresql.org
irc#postgresql

Top users

Tom Lane: 4096 posts Scott Marlowe: 788 posts Kevin Grittner: 784 posts Bruce Momjian: 595 posts Peter Eisentraut: 520 posts Alvaro Herrera: 393 posts Joshua D. Drake: 374 posts Mendola: 313 posts Bruno Wolff III: 311 posts Michael Fuhr: 275 posts Robert Treat: 245 posts Scott Marlowe: 244 posts Jim C. Nasby: 241 posts Stephan Szabo: 235 posts Simon Riggs: 228 posts Jeff Frost: 226 posts Rajesh Kumar Mallah: 214 posts Chris Browne: 208 posts Scott.marlowe: 193 posts Tena Sakai: 184 posts
show more
Archives