Administration

Do, Elvis L | 1 Feb 2011 01:35

pgagent fails to start by service command on redhat enterprise 5

Dear pgsql-admin,

Current operation system: Red hat Enterprise version 5.0.

I downloaded wxGTK (2.8.0) zip file from www.wxwidgests.org and build and install it.

I downloaded pgadmin3 (1.8.0) RPM source code from pgadmin website http://www.postgresql.org/ftp/pgadmin3/release/v1.8.0/src/ and build it. (This will include pgagent).

I can start pgagent from command line as without error and pgagent job schedule worked fine.

%/path to pgadmin3/bin/pgagent hostaddr=127.0.0.1 dbname=postgres user=postgres

However, when I tried to set up script to start pgagent when system reboot as from this link (http://www.postgresonline.com/journal/index.php?/archives/86-Yum-addendum-for-8.3.5-and-PgAgent.html) , I got error when I ran command service to start pgagent.

#service pgagent start

Starting PgAgent: /usr/local/pgadmin3/bin/pgagent: error while loading shared libraries: libwx_baseeu-2.8.so.0: cannot open shared object file: No such file or directory

Do you have any suggestion on this?

Thanks,

Elvis

headers

Ray Stell | 2 Feb 2011 21:46

unexpected pageaddr

Streaming replication standby moved from 9.0.2->9.0.3 logs this up 
startup:

 database system was shut down in recovery at 2011-02-02 15:28:51 EST
 entering standby mode
 redo starts at 0/65000170
 consistent recovery state reached at 0/66000000
 unexpected pageaddr 0/62000000 in log file 0, segment 102, offset 0
 database system is ready to accept read only connections
 streaming replication successfully connected to primary

Is the standby hurt?

--

-- 
Sent via pgsql-admin mailing list (pgsql-admin <at> postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

headers

Tom Lane | 3 Feb 2011 00:32

Re: unexpected pageaddr

Ray Stell <stellr <at> cns.vt.edu> writes:
> Streaming replication standby moved from 9.0.2->9.0.3 logs this up 
> startup:

>  database system was shut down in recovery at 2011-02-02 15:28:51 EST
>  entering standby mode
>  redo starts at 0/65000170
>  consistent recovery state reached at 0/66000000
>  unexpected pageaddr 0/62000000 in log file 0, segment 102, offset 0
>  database system is ready to accept read only connections
>  streaming replication successfully connected to primary

> Is the standby hurt?

"unexpected pageaddr" is just one of the standard tests for detecting
end of WAL, so I don't think this is anything to be surprised about.
It looks to me like the standby applied all the WAL it had and then
connected to the master for more.

			regards, tom lane

--

-- 
Sent via pgsql-admin mailing list (pgsql-admin <at> postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

headers

Ray Stell | 3 Feb 2011 00:43

Re: unexpected pageaddr

On Wed, Feb 02, 2011 at 06:32:22PM -0500, Tom Lane wrote:
> Ray Stell <stellr <at> cns.vt.edu> writes:
> > Streaming replication standby moved from 9.0.2->9.0.3 logs this up 
> > startup:
> 
> >  database system was shut down in recovery at 2011-02-02 15:28:51 EST
> >  entering standby mode
> >  redo starts at 0/65000170
> >  consistent recovery state reached at 0/66000000
> >  unexpected pageaddr 0/62000000 in log file 0, segment 102, offset 0
> >  database system is ready to accept read only connections
> >  streaming replication successfully connected to primary
> 
> > Is the standby hurt?
> 
> "unexpected pageaddr" is just one of the standard tests for detecting
> end of WAL, so I don't think this is anything to be surprised about.
> It looks to me like the standby applied all the WAL it had and then
> connected to the master for more.
> 
> 			regards, tom lane

thanks, Tom.  I suppose it's the order that trips me up:

 starts at 65...
 reached a 66...
 unexpected at 62...

Maybe you could say a few words on the flow logic.  
I suppose it depends on what is meant by "start."

--

-- 
Sent via pgsql-admin mailing list (pgsql-admin <at> postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

headers

Tom Lane | 3 Feb 2011 00:57

Re: unexpected pageaddr

Ray Stell <stellr <at> cns.vt.edu> writes:
> On Wed, Feb 02, 2011 at 06:32:22PM -0500, Tom Lane wrote:
>> "unexpected pageaddr" is just one of the standard tests for detecting
>> end of WAL, so I don't think this is anything to be surprised about.
>> It looks to me like the standby applied all the WAL it had and then
>> connected to the master for more.

> thanks, Tom.  I suppose it's the order that trips me up:

>  starts at 65...
>  reached a 66...
>  unexpected at 62...

Well, the point of the "unexpected pageaddr" message is exactly that the
WAL location it found in the next file wasn't the expected next location
in sequence (which would have to be something larger than 0/66000000).
This indicates that the next file isn't really new WAL, but a segment
file that was recycled (by renaming it to a higher file number) but not
yet overwritten with new data.

			regards, tom lane

--

-- 
Sent via pgsql-admin mailing list (pgsql-admin <at> postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

headers

Adarsh Sharma | 3 Feb 2011 09:57

Select Command in Procedures

Dear all,

I am able to execute command successfully through CLI or pgAdmin .

create table user_news_new as select record_id,field_name,field_value,news_date from user_news where field_name in ('SOI','RelLoc','Description','Heading','news_date') and field_value != '' ;

But I don't know when I put this command in a procedure, it shows error :

CREATE FUNCTION user10() RETURNS void AS'
DECLARE
BEGIN
create table user_news_new as select record_id,field_name,field_value,news_date from user_news where field_name in ('SOI','RelLoc','Description','Heading','news_date') and field_value != '' ;
END;
' LANGUAGE 'plpgsql';

Error :

globe=# CREATE FUNCTION user10() RETURNS void AS'
globe'# DECLARE
globe'# BEGIN
globe'# create table user_news_new as select record_id,field_name,field_value,news_date from user_news where field_name in ('SOI','RelLoc','Description','Heading','news_date') and field_value != '' ;
globe'# END;
globe'# ' LANGUAGE 'plpgsql';
ERROR: syntax error at or near "SOI"
LINE 4: ...ue,news_date from user_news where field_name in ('SOI','RelL...
^

Please help as I stuck with this issue.

Thanks & Regards

Adarsh Sharma

headers

Christian Ullrich | 3 Feb 2011 10:34

Re: Select Command in Procedures

* Adarsh Sharma wrote:

> I am able to execute command successfully through CLI or pgAdmin .
>
> *create table user_news_new as select
> record_id,field_name,field_value,news_date from user_news where
> field_name in ('SOI','RelLoc','Description','Heading','news_date') and
> field_value != '' ; *
>
> But I don't know when I put this command in a procedure, it shows error :
>
> CREATE FUNCTION user10() RETURNS void AS'
> DECLARE
> BEGIN
> create table user_news_new as select
> record_id,field_name,field_value,news_date from user_news where
> field_name in ('SOI','RelLoc','Description','Heading','news_date') and
> field_value != '' ;
> END;
> ' LANGUAGE 'plpgsql';

You are using single quotation marks around your function body already. 
Use dollar quoting instead.

-- 
Christian

--

-- 
Sent via pgsql-admin mailing list (pgsql-admin <at> postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

headers

Gnanakumar | 3 Feb 2011 13:00

Is there a batch/bulk UPDATE syntax available?

Hi,

Is there a batch/bulk UPDATE query syntax available in PostgreSQL, similar
to multirow VALUES syntax available for INSERT?

INSERT Multirow VALUES syntax example:
INSERT INTO films (code, title, did, date_prod, kind) VALUES
    ('B6717', 'Tampopo', 110, '1985-02-10', 'Comedy'),
    ('HG120', 'The Dinner Game', 140, DEFAULT, 'Comedy');

There is a situation in my application, where I am performing lots and lots
of updates on individual rows. I am trying to figure out how to make the
updates faster.

Any other ideas/ways to make updates faster are highly appreciated.

Regards,
Gnanam

--

-- 
Sent via pgsql-admin mailing list (pgsql-admin <at> postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

headers

Thomas Kellerer | 3 Feb 2011 13:31

Re: Is there a batch/bulk UPDATE syntax available?

Gnanakumar, 03.02.2011 13:00:
> Is there a batch/bulk UPDATE query syntax available in PostgreSQL, similar
> to multirow VALUES syntax available for INSERT?
>
> INSERT Multirow VALUES syntax example:
> INSERT INTO films (code, title, did, date_prod, kind) VALUES
>      ('B6717', 'Tampopo', 110, '1985-02-10', 'Comedy'),
>      ('HG120', 'The Dinner Game', 140, DEFAULT, 'Comedy');
>
> There is a situation in my application, where I am performing lots and lots
> of updates on individual rows. I am trying to figure out how to make the
> updates faster.
>
> Any other ideas/ways to make updates faster are highly appreciated.
>
> Regards,
> Gnanam
>
>
Maybe this pattern would work for you:

UPDATE my_table
    SET the_column = CASE
                       WHEN some_id_column = 1 then 100
                       WHEN some_id_column = 2 then 200
                       WHEN some_id_column = 3 then 300
                       WHEN some_id_column = 4 then 400
                       WHEN some_id_column = 5 then 500
                     END
WHERE some_id_column IN (1,2,3,4,5)

But that get's pretty nasty if you have more than just those 5 rows.

--

-- 
Sent via pgsql-admin mailing list (pgsql-admin <at> postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

headers

pasman pasmański | 3 Feb 2011 21:30

Re: Is there a batch/bulk UPDATE syntax available?

Show us explain analyze for this update.

2011/2/3, Gnanakumar <gnanam <at> zoniac.com>:
> Hi,
>
> Is there a batch/bulk UPDATE query syntax available in PostgreSQL, similar
> to multirow VALUES syntax available for INSERT?
>
> INSERT Multirow VALUES syntax example:
> INSERT INTO films (code, title, did, date_prod, kind) VALUES
>     ('B6717', 'Tampopo', 110, '1985-02-10', 'Comedy'),
>     ('HG120', 'The Dinner Game', 140, DEFAULT, 'Comedy');
>
> There is a situation in my application, where I am performing lots and lots
> of updates on individual rows. I am trying to figure out how to make the
> updates faster.
>
> Any other ideas/ways to make updates faster are highly appreciated.
>
> Regards,
> Gnanam
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin <at> postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>

-- 
------------
pasman

--

-- 
Sent via pgsql-admin mailing list (pgsql-admin <at> postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

106	May 2013
152	April 2013
47	March 2013
87	February 2013
132	January 2013
137	December 2012
168	November 2012
123	October 2012
177	September 2012
121	August 2012
103	July 2012
126	June 2012
98	May 2012
151	April 2012
149	March 2012
128	February 2012
146	January 2012
155	December 2011
162	November 2011
136	October 2011
216	September 2011
247	August 2011
207	July 2011
152	June 2011
187	May 2011
256	April 2011
300	March 2011
230	February 2011
197	January 2011
206	December 2010
263	November 2010
223	October 2010
196	September 2010
289	August 2010
232	July 2010
238	June 2010
299	May 2010
374	April 2010
287	March 2010
177	February 2010
89	January 2010
131	December 2009
154	November 2009
204	October 2009
180	September 2009
209	August 2009
261	July 2009
234	June 2009
122	May 2009
231	April 2009
277	March 2009
273	February 2009
172	January 2009
214	December 2008
179	November 2008
200	October 2008
360	September 2008
247	August 2008
247	July 2008
259	June 2008
254	May 2008
321	April 2008
279	March 2008
406	February 2008
298	January 2008
260	December 2007
271	November 2007
328	October 2007
158	September 2007
376	August 2007
347	July 2007
314	June 2007
344	May 2007
255	April 2007
246	March 2007
346	February 2007
307	January 2007
359	December 2006
257	November 2006
219	October 2006
388	September 2006
352	August 2006
292	July 2006
286	June 2006
430	May 2006
362	April 2006
403	March 2006
312	February 2006
309	January 2006
366	December 2005
347	November 2005
290	October 2005
340	September 2005
402	August 2005
264	July 2005
302	June 2005
323	May 2005
403	April 2005
514	March 2005
322	February 2005
306	January 2005
267	December 2004
206	November 2004
380	October 2004
285	September 2004
309	August 2004
318	July 2004
411	June 2004
333	May 2004
333	April 2004
387	March 2004
383	February 2004
301	January 2004
362	December 2003
520	November 2003
415	October 2003
468	September 2003
362	August 2003
383	July 2003
343	June 2003
419	May 2003
405	April 2003
490	March 2003
432	February 2003
361	January 2003
340	December 2002
305	November 2002
330	October 2002
321	September 2002
421	August 2002
421	July 2002
253	June 2002
260	May 2002
216	April 2002
6	March 2002
1	February 2001
2	January 1990

Mon	Tue	Wed	Thu	Fri	Sat	Sun

	1	2	3	4	5	6
7	8	9	10	11	12	13
14	15	16	17	18	19	20
21	22	23	24	25	26	27
28