Re: [GENERAL] FATAL: shmat(id=3342337) failed: Cannot allocate memory

Thanks John, but someone have just fixed the problem. I still need to find out about the fix. -Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of John R Pierce Sent: Wednesday, April 24, 2013 8:18 AM To: pgsql-general@postgre

Re: [GENERAL] FATAL: shmat(id=3342337) failed: Cannot allocate memory

On 4/23/2013 11:08 PM, Khangelani Gama wrote: Hi John Yes that's the whole messege well, try something like... kernel.shmmax = 4294967295 kernel.shmall = 268435456 at the end of /etc/sysctl.conf, then execute `sysctl -p` and try to start postgres again. (it really doesn't matte

Re: [GENERAL] FATAL: shmat(id=3342337) failed: Cannot allocate memory

# cat /proc/meminfo MemTotal:8273364 kB MemFree: 6455204 kB Buffers: 99180 kB Cached: 564436 kB SwapCached:0 kB Active: 1191560 kB Inactive: 500768 kB Active(anon):1032072 kB Inactive(anon): 456 kB Active(file): 159488 k

Re: [GENERAL] FATAL: shmat(id=3342337) failed: Cannot allocate memory

Hi John Yes that's the whole messege # free -m total used free sharedbuffers cached Mem: 8079 1770 6309 0 95549 -/+ buffers/cache: 1125 6953 Swap: 1023 0 1023 Thanks -Or

Re: [GENERAL] FATAL: shmat(id=3342337) failed: Cannot allocate memory

On 4/23/2013 10:53 PM, Khangelani Gama wrote: We are running postgres 9.1 on CentOS 5. We can’t start up postgres . It complains about memory allocation . Please help FATAL: shmat(id=3342337) failed: Cannot allocate memory is that the entire error message? it usually says something about

[GENERAL] FATAL: shmat(id=3342337) failed: Cannot allocate memory

Hi all We are running postgres 9.1 on CentOS 5. We can’t start up postgres . It complains about memory allocation . Please help FATAL: shmat(id=3342337) failed: Cannot allocate memory # - Memory - shared_buffers = 310251 # (change requires r

Re: [GENERAL] inserting into "date" field returns error (COPY/BINARY)

Merlin, it worked like a charm! Thank you tons! Konstantin

Re: [GENERAL] run COPY as user other than postgres

On Tue, Apr 23, 2013 at 1:11 PM, Kirk Wythers wrote: > I would like to run the COPY command as a user other than "postgres". I find > it a bit of a pain (or at least requiring an extra step or two) to have the > postgres user own the files that I am creating with COPY TO. Here is a simple > exa

Re: [GENERAL] Log messages regarding automatic vacuum and exclusive locks

On Tue, Apr 23, 2013 at 8:50 AM, wrote: > Good morning. I'm seeing several of the following log messages each morning > (for example, there were five this morning, spaced approximately one minute > apart, with the closest interval between messages being 44 seconds). > They're occurring during a

Re: [GENERAL] Regarding template1 database

On 4/23/2013 7:26 AM, S H wrote: ... template1 vacuuming with Analyze is executed through cron job every one hour and some times it is taking lot of time what do you get from... $ sudo -u postgres psql template1 psql (9.2.4) Type "help" for help. template1=# \d No relation

Re: [GENERAL] Regarding template1 database

On 04/23/2013 07:26 AM, S H wrote: I am working on some legacy product. In which template1 vacuuming with Analyze is executed through cron job every one hour and some times it is taking lot of time. I want to know if there is any major update/insert in template1 at some time, so i wanted to monit

Re: [GENERAL] Regarding template1 database

On 4/24/13, S H wrote: > I am working on some legacy product. In which template1 vacuuming with > Analyze is executed through cron job every one hour and some times it is > taking lot of time.I want to know if there is any major update/insert in > template1 at some time, so i wanted to monitor the

Re: [GENERAL] Log messages regarding automatic vacuum and exclusive locks

"jon...@xmission.com" wrote: > I'm seeing several of the following log messages each > morning (for example, there were five this morning, spaced > approximately one minute apart, with the closest interval between > messages being 44 seconds).  They're occurring during a daily cycle of > dele

Re: [GENERAL] pg_stop_backup running for 2h10m?

Le 2013-04-23 à 16:25, Kevin Grittner a écrit : > François Beausoleil wrote: > >> xlogs aren't being added to the backup directory. > > Any clue in the server log why that is? I checked but didn't mention it. I ended up calling pg_cancel_backend() on the process, after 3h. strace on the proc

Re: [GENERAL] pg_stop_backup running for 2h10m?

François Beausoleil wrote: > xlogs aren't being added to the backup directory. Any clue in the server log why that is? -- Kevin Grittner EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make c

Re: [GENERAL] Negative replication lag?

Ah, that makes sense. I think I'll add some logic to the script that has it get new data points if it comes up with a negative value. Thanks for the insight. QH On Mon, Apr 22, 2013 at 5:11 PM, Andres Freund wrote: > On 2013-04-22 16:36:38 -0600, Quentin Hartman wrote: > > I'm using this scrip

Re: [GENERAL] run COPY as user other than postgres

On Tue, Apr 04/23/13, 2013 at 03:11:21PM -0500, Kirk Wythers wrote: > I would like to run the COPY command as a user other than "postgres". > I find it a bit of a pain (or at least requiring an extra step or two) > to have the postgres user own the files that I am creating with COPY > TO. Here is a

[GENERAL] run COPY as user other than postgres

I would like to run the COPY command as a user other than "postgres". I find it a bit of a pain (or at least requiring an extra step or two) to have the postgres user own the files that I am creating with COPY TO. Here is a simple example where the location '/some/path/to/file/file.csv' is owned

Re: [GENERAL] pg_stop_backup running for 2h10m?

Le 2013-04-23 à 15:08, François Beausoleil a écrit : > I used omnipitr to launch a base backup, but I fumbled a couple of things, so > I Ctrl+C'd *once* the console where I had omnipitr-backup-master running. > omnipitr-backup-master correctly launched pg_stop_backup, but pg_stop_backup > has

[GENERAL] pg_stop_backup running for 2h10m?

Hi, I used omnipitr to launch a base backup, but I fumbled a couple of things, so I Ctrl+C'd *once* the console where I had omnipitr-backup-master running. omnipitr-backup-master correctly launched pg_stop_backup, but pg_stop_backup has been active for 2h10 minutes, as reported by pg_stat_activ

Re: [GENERAL] Regression test fails v9.2.4

Manning John wrote: > [regression tests have different plans or row orderings] > It seems that the problem only occurs when configuring the make > with these settings : > > --with-libraries=/lib64 --with-blocksize=2 --with-wal-blocksize=2 > is this problem common, i.e. the expected results fil

[GENERAL] Log messages regarding automatic vacuum and exclusive locks

Good morning. I'm seeing several of the following log messages each morning (for example, there were five this morning, spaced approximately one minute apart, with the closest interval between messages being 44 seconds). They're occurring during a daily cycle of deleting all rows from a t

[GENERAL] make uninstall deletes all manpages?

I just tried make uninstall. I did: sudo make uninstall which goes: make -C doc uninstall make -C src uninstall make -C sgml uninstall rm -f '/opt/local/share/doc//postgresql/html/'* '/opt/local/share/man'/man1/* '/opt/local/share/man'/man3/* '/opt/local/share/man'/man7/* /bin/sh: /bin/rm: Argume

Re: [GENERAL] Regarding template1 database

I am working on some legacy product. In which template1 vacuuming with Analyze is executed through cron job every one hour and some times it is taking lot of time.I want to know if there is any major update/insert in template1 at some time, so i wanted to monitor the number of insertions and del

Re: [GENERAL] Memory usage after upgrade to 9.2.4

2013/4/23 Adrian Klaver > On 04/23/2013 04:23 AM, Daniel Cristian Cruz wrote: > >> 2013/4/22 Daniel Cristian Cruz > > >> >> >> query1: >> EXPLAIN ANALYZE SELECT ced.id_evento, ced.inicio, ced.termino, >> ced.evento, ced.id_eventos IS NOT NULL AS aul

Re: [GENERAL] Regarding template1 database

On 04/22/2013 08:08 PM, S H wrote: > - I want to know the tables of tempate1 There are none, unless you choose to add some. I got it there are no tables. What about the system tables of template1 database ? Are they updated or not? > > - If i want to monitor the transactions done in the temp

Re: [GENERAL] Memory usage after upgrade to 9.2.4

On 04/23/2013 04:23 AM, Daniel Cristian Cruz wrote: 2013/4/22 Daniel Cristian Cruz mailto:danielcrist...@gmail.com>> query1: EXPLAIN ANALYZE SELECT ced.id_evento, ced.inicio, ced.termino, ced.evento, ced.id_eventos IS NOT NULL AS aula_dividida, ac.titulo, ced.id_tipo_evento, ced.

Re: [GENERAL] using text search

Ha! Got it! for enybody whois interested: with tst(regexp) as (SELECT '(' || array_to_string(array_agg(phrase), '|') || ')' from KEYWORDS) select o.* from ORDERS o, tst t where o.info ~ t.regexp; execution time: 6400ms. (keywords=4, orders=1mln) BTW: does anybody know if there is an index,

Re: [GENERAL] inserting into "date" field returns error (COPY/BINARY)

On Tue, Apr 23, 2013 at 2:54 AM, Konstantin Izmailov wrote: > I have implemented a C++ procedure for inserting data using libpq and COPY > WITH BINARY command. All field types are working as expected in PG9.2, > except "date": > ERROR: incorrect binary data format > CONTEXT: COPY table, line

Re: [GENERAL] using text search

Hi Rafal This function returns the position where the substring is found, so you could do a query with clause position(table1.field in table2.field) The 0 result is not found and maybe, in your case, is faster the use of internal text functions instead of like comparison... hope helps. Bye El

Re: [GENERAL] Regression test fails v9.2.4

Sorry - replying to my own question It seems that the problem only occurs when configuring the make with these settings : --with-libraries=/lib64 --with-blocksize=2 --with-wal-blocksize=2 Now, we *could* do a two phase compile, one to perform regression tests and another for deployment. Cl

Re: [GENERAL] Memory usage after upgrade to 9.2.4

2013/4/22 Daniel Cristian Cruz > query1: > EXPLAIN ANALYZE SELECT ced.id_evento, ced.inicio, ced.termino, ced.evento, > ced.id_eventos IS NOT NULL AS aula_dividida, ac.titulo, ced.id_tipo_evento, > ced.tipo_evento, ac.media_referencia, p.nome, ef.nome AS nomeEspacoFisico, > ( SELECT count ( pre2.

[GENERAL] Streaming replication and pg_dump

Hi, I have a streaming replication slave, which I've setup for backup purposes only. After running pg_dump on it (took around 8 hours) I ended up with 64 ".ready" files in pg_xlog/archive_status. These files have been there now for more than 24 hours. These are some related configuration setting

Re: [GENERAL] using text search

W dniu 04/22/2013 08:43 PM, Alfonso Afonso pisze: I forgot to say that the function is "position ( txtseach in txtcomplete)" :) Bye Alfonso, thenx But if I may: How can I use that function? In a context of my problem? then again. At the edge of desperation, I'm thinking of writing a funct

[GENERAL] inserting into "date" field returns error (COPY/BINARY)

I have implemented a C++ procedure for inserting data using libpq and COPY WITH BINARY command. All field types are working as expected in PG9.2, except "date": ERROR: incorrect binary data format CONTEXT: COPY table, line 1, column date_xyz The passed value for "date" is a 64-bit integer, c

Re: [GENERAL] bug in 8.4 and resolved

On 04/23/2013 12:29 AM, John R Pierce wrote: On 4/22/2013 3:13 PM, Thomas Kellerer wrote: Abhinav Dwivedi wrote on 22.04.2013 07:12: select * from district where statecode in (Select districtcode from state) Please note that the attribute districtcode is not existent in the table state and i

Re: [GENERAL] Regarding template1 database

On 4/22/2013 8:08 PM, S H wrote: I want to monitor externally, without changing the database. If there are some system queries which can tell me what are the number of database insertion/updation in the template1 ( including system table it will be helpful for me). the system tables include t