Pgsql Training.

This is a multi-part message in MIME format.

------_=_NextPart_001_01CAC52F.0FA393ED
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

All,

Just signed up on the list. We are in the process of adopting pgsql over
mysql. I was wondering if someone can suggest any reasonably priced
training for pgsql Administration and development. We are in southern
CA. So anything closer to LA will be convenient and preferred.

There is lots of information on web, but any word from this lists will
have lot more weight.



Thank you,

-Jai




------_=_NextPart_001_01CAC52F.0FA393ED
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" =
xmlns=3D"http://www.w3.org/TR/REC-html40">

<head>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
[at] font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
..MsoChpDefault
{mso-style-type:export-only;}
[at] page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]-->
</head>

<body lang=3DEN-US link=3Dblue vlink=3Dpurple>

<div class=3DSection1>

<p class=3DMsoNormal>All,<o:p></o:p></p>

<p class=3DMsoNormal>Just signed up on the list. We are in the process =
of adopting
pgsql over mysql. I was wondering if someone can suggest any reasonably =
priced
training for pgsql Administration and development. We are in southern =
CA. So
anything closer to LA will be convenient and preferred.  =
<o:p></o:p></p>

<p class=3DMsoNormal>There is lots of information on web, but any word =
from this lists
will have lot more weight.   <o:p></o:p></p>

<p class=3DMsoNormal><o:p> </o:p></p>

<p class=3DMsoNormal>Thank you,<o:p></o:p></p>

<p class=3DMsoNormal>-Jai<o:p></o:p></p>

<p class=3DMsoNormal><o:p> </o:p></p>

</div>

</body>

</html>

------_=_NextPart_001_01CAC52F.0FA393ED--
jrangi [ Di, 16 März 2010 18:35 ] [ ID #2035248 ]

WAL filles

This is a multi-part message in MIME format.

------_=_NextPart_001_01CAC534.717276A0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hi folks,



I was wandering if I can get some ideas about what I am doing wrong.



So I setup 2 servers one primary one secondary for archiving.



Followed all the steps and such. On the initial start of the standby
server it reads all the WAL files and acts like it should. The issue
is, when new WAL files start to arrive say

000000010000000000000049

the system starts creating



00000002.history

000000020000000000000049



And the updates are not propagated.



Any ideas?



Thanks,

Vitaly Burshteyn

Senior Network Engineer

Broadway.com, Theatre Direct International

729 7th Avenue

New York, New York 10019

Phone: 212.817.9117

Cell# 917-701-5732






____________________________________=0D
The information contained in this transmission may contain privileged =0D
and confidential information. It is intended only for the use of the =0D
person(s) named above. If you are not the intended recipient, you are =0D
hereby notified that any review, dissemination, distribution or =0D
duplication of this communication is strictly prohibited. If you are =0D
not the intended recipient, please contact the sender by reply email =0D
and destroy all copies of the original message.

------_=_NextPart_001_01CAC534.717276A0
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schemas-micr=
osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" xmlns=3D"http:=
//www.w3.org/TR/REC-html40">

<head>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
[at] font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
[at] font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
[at] font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
..MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
[at] page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]-->
</head>

<body lang=3DEN-US link=3Dblue vlink=3Dpurple>

<div class=3DSection1>

<p class=3DMsoNormal><span style=3D'color:#1F497D'>Hi folks,<o:p></o:p></sp=
an></p>

<p class=3DMsoNormal><span style=3D'color:#1F497D'><o:p> </o:p></span>=
</p>

<p class=3DMsoNormal><span style=3D'color:#1F497D'>I was wandering if I can=
get
some ideas about what I am doing wrong.<o:p></o:p></span></p>

<p class=3DMsoNormal><span style=3D'color:#1F497D'><o:p> </o:p></span>=
</p>

<p class=3DMsoNormal><span style=3D'color:#1F497D'>So I setup 2 servers one=
primary
one secondary for archiving.<o:p></o:p></span></p>

<p class=3DMsoNormal><span style=3D'color:#1F497D'><o:p> </o:p></span>=
</p>

<p class=3DMsoNormal><span style=3D'color:#1F497D'>Followed all the steps a=
nd
such.  On the initial start of the standby server it reads all the WAL=
files
and acts like it should.  The issue is, when new WAL files start to ar=
rive say <o:p></o:p></span></p>

<p class=3DMsoNormal><span style=3D'color:#1F497D'>000000010000000000000049=
<o:p></o:p></span></p>

<p class=3DMsoNormal><span style=3D'color:#1F497D'>the system starts creati=
ng <o:p></o:p></span></p>

<p class=3DMsoNormal><span style=3D'color:#1F497D'><o:p> </o:p></span>=
</p>

<p class=3DMsoNormal><span style=3D'color:#1F497D'>00000002.history<o:p></o=
:p></span></p>

<p class=3DMsoNormal><span style=3D'color:#1F497D'>000000020000000000000049=
<o:p></o:p></span></p>

<p class=3DMsoNormal><span style=3D'color:#1F497D'><o:p> </o:p></span>=
</p>

<p class=3DMsoNormal><span style=3D'color:#1F497D'>And the updates are not
propagated.<o:p></o:p></span></p>

<p class=3DMsoNormal><span style=3D'color:#1F497D'><o:p> </o:p></span>=
</p>

<p class=3DMsoNormal><span style=3D'color:#1F497D'>Any ideas?<o:p></o:p></s=
pan></p>

<p class=3DMsoNormal><span style=3D'color:#1F497D'><o:p> </o:p></span>=
</p>

<p class=3DMsoNormal><span style=3D'color:#1F497D'>Thanks,<o:p></o:p></span=
></p>

<div>

<p class=3DMsoNormal><span style=3D'font-size:10.5pt;font-family:Consolas;
color:#1F497D'>Vitaly Burshteyn<o:p></o:p></span></p>

<p class=3DMsoNormal><span style=3D'font-size:10.5pt;font-family:Consolas;
color:#1F497D'>Senior Network Engineer<o:p></o:p></span></p>

<p class=3DMsoNormal><span style=3D'font-size:10.5pt;font-family:Consolas;
color:#1F497D'>Broadway.com, Theatre Direct International<o:p></o:p></span>=
</p>

<p class=3DMsoNormal><span style=3D'font-size:10.5pt;font-family:Consolas;
color:#1F497D'>729  7th Avenue<o:p></o:p></span></p>

<p class=3DMsoNormal><span style=3D'font-size:10.5pt;font-family:Consolas;
color:#1F497D'>New York, New York 10019<o:p></o:p></span></p>

<p class=3DMsoNormal><span style=3D'font-size:10.5pt;font-family:Consolas;
color:#1F497D'>Phone: 212.817.9117<o:p></o:p></span></p>

<p class=3DMsoNormal><span style=3D'font-size:10.5pt;font-family:Consolas;
color:#1F497D'>Cell# 917-701-5732</span><span style=3D'color:#1F497D'><o:p>=
</o:p></span></p>

</div>

<p class=3DMsoNormal><span style=3D'color:#1F497D'><o:p> </o:p></span>=
</p>

<p class=3DMsoNormal><o:p> </o:p></p>

</div>


</body>

</html>

------_=_NextPart_001_01CAC534.717276A0--
Vitaly Burshteyn [ Di, 16 März 2010 19:13 ] [ ID #2035249 ]

Re: Pgsql Training.

On Tue, 2010-03-16 at 10:35 -0700, Rangi, Jai wrote:
> All,
>
> Just signed up on the list. We are in the process of adopting pgsql
> over mysql. I was wondering if someone can suggest any reasonably
> priced training for pgsql Administration and development. We are in
> southern CA. So anything closer to LA will be convenient and
> preferred.

EntperiseDB offers some great Web based training...


Joshua D. Drake


>
> There is lots of information on web, but any word from this lists will
> have lot more weight.
>
>
>
> Thank you,
>
> -Jai
>
>
>
>


--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
Consulting, Training, Support, Custom Development, Engineering
Respect is earned, not gained through arbitrary and repetitive use or Mr. or Sir.


--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Joshua Drake [ Di, 16 März 2010 19:56 ] [ ID #2035250 ]

Re: WAL filles

"Vitaly Burshteyn" <vburshteyn [at] broadway.com> wrote:

> Followed all the steps and such. On the initial start of the
> standby server it reads all the WAL files and acts like it should.
> The issue is, when new WAL files start to arrive say
>
> 000000010000000000000049
>
> the system starts creating
>
>
>
> 00000002.history
>
> 000000020000000000000049
>
>
>
> And the updates are not propagated.
>
>
>
> Any ideas?

As a shot in the dark, is your recovery script exiting with 1 if it
can't find a file which has a name other than 24 hexadecimal
characters? (Hint: It should.)

If that's not the issue, please review this page and repost with
more information:

http://wiki.postgresql.org/wiki/Guide_to_reporting_problems

-Kevin

--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Kevin Grittner [ Di, 16 März 2010 21:19 ] [ ID #2035251 ]

Re: Pgsql Training.

Rangi, Jai wrote:
>
> All,
>
> Just signed up on the list. We are in the process of adopting pgsql
> over mysql. I was wondering if someone can suggest any reasonably
> priced training for pgsql Administration and development. We are in
> southern CA. So anything closer to LA will be convenient and preferred.
>
> There is lots of information on web, but any word from this lists will
> have lot more weight.
>
The Open Technology Group offers hands-on instructor led training, both
in a classroom setting as well as virtually in a live instructor-led
course. We also offer training "packages" that include the cost of
airfare and hotel accommodation...

We also offer on-site training that's affordable for groups as small as
3 people.

Let me know if you'd like more information...

--
Chander Ganesan
Open Technology Group, Inc.
One Copley Parkway, Suite 210
Morrisville, NC 27560
919-463-0999/877-258-8987
http://www.otg-nc.com
Export PostgreSQL, PostGIS, Python and other and Open Source training.


--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
chander [ Di, 16 März 2010 21:38 ] [ ID #2035252 ]

Re: Pgsql Training.

Thank you everyone who responded. I got enough information at this time
and will be making decision in next few weeks. Appreciate everyone for
prompt responses.

Best,
-Jai

-----Original Message-----
From: pgsql-admin-owner [at] postgresql.org
[mailto:pgsql-admin-owner [at] postgresql.org] On Behalf Of Chander Ganesan
Sent: Tuesday, March 16, 2010 1:39 PM
To: Rangi, Jai
Cc: pgsql-admin [at] postgresql.org
Subject: Re: [ADMIN] Pgsql Training.

Rangi, Jai wrote:
>
> All,
>
> Just signed up on the list. We are in the process of adopting pgsql
> over mysql. I was wondering if someone can suggest any reasonably
> priced training for pgsql Administration and development. We are in
> southern CA. So anything closer to LA will be convenient and
preferred.
>
> There is lots of information on web, but any word from this lists will

> have lot more weight.
>
The Open Technology Group offers hands-on instructor led training, both
in a classroom setting as well as virtually in a live instructor-led
course. We also offer training "packages" that include the cost of
airfare and hotel accommodation...

We also offer on-site training that's affordable for groups as small as
3 people.

Let me know if you'd like more information...

--
Chander Ganesan
Open Technology Group, Inc.
One Copley Parkway, Suite 210
Morrisville, NC 27560
919-463-0999/877-258-8987
http://www.otg-nc.com
Export PostgreSQL, PostGIS, Python and other and Open Source training.


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

--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
jrangi [ Mi, 17 März 2010 00:45 ] [ ID #2035389 ]
Datenbanken » gmane.comp.db.postgresql.admin » Pgsql Training.

Vorheriges Thema: Autovac vs manual with analyze
Nächstes Thema: Mixing DBLink versions