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. =20

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

=20

Thank you,

-Jai

=20


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

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">


charset=3Dus-ascii">

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,

=20

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

=20

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

=20

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=20

000000010000000000000049

the system starts creating=20

=20

00000002.history

000000020000000000000049

=20

And the updates are not propagated.

=20

Any ideas?

=20

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

=20

=20


____________________________________=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

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">

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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: WAL filles

"Vitaly Burshteyn" 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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

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.=20

Best,
-Jai

-----Original Message-----
From: pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Chander Ganesan
Sent: Tuesday, March 16, 2010 1:39 PM
To: Rangi, Jai
Cc: pgsql-admin@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=20
> over mysql. I was wondering if someone can suggest any reasonably=20
> priced training for pgsql Administration and development. We are in=20
> southern CA. So anything closer to LA will be convenient and
preferred.=20
>
> 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=20
in a classroom setting as well as virtually in a live instructor-led=20
course. We also offer training "packages" that include the cost of=20
airfare and hotel accommodation...

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

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

--=20
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.


--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin