Thread: [GENERAL] Postgresql and github

[GENERAL] Postgresql and github

From
Poul Kristensen
Date:
Hi!

How come that Postgresql is not present in a github with latest release?

It would be very convenient to deploy PG using Ansible.

Oracle(latest release) is available through github.

TIA

Poul


Re: [GENERAL] Postgresql and github

From
Michael Paquier
Date:
On Thu, Nov 9, 2017 at 8:27 PM, Poul Kristensen <bcc5226@gmail.com> wrote:
> How come that Postgresql is not present in a github with latest release?
>
> It would be very convenient to deploy PG using Ansible.
>
> Oracle(latest release) is available through github.

You are looking for that, which is a mirror of the official repository
in git.postgresql.org:
https://github.com/postgres/postgres
There is as well a section with release tarballs (so do the facilities
offered by community by the way).
-- 
Michael


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

Re: [GENERAL] Postgresql and github

From
"Igal @ Lucee.org"
Date:
On 11/9/2017 3:27 AM, Poul Kristensen wrote:
How come that Postgresql is not present in a github with latest release?

What do you mean?  Is this not what you're referring to:
    https://github.com/postgres/postgres/releases
?

Igal Sapir
Lucee Core Developer
Lucee.org

Re: [GENERAL] Postgresql and github

From
Poul Kristensen
Date:
No it isn't.

What I want to do is:

ansible-playbook   somepostgresql.yml 

and postgresql is then changed on some server
the way things are done by e.g.

Thanks 
Poul



2017-11-09 17:18 GMT+01:00 Igal @ Lucee.org <igal@lucee.org>:
On 11/9/2017 3:27 AM, Poul Kristensen wrote:
How come that Postgresql is not present in a github with latest release?

What do you mean?  Is this not what you're referring to:
    https://github.com/postgres/postgres/releases
?

Igal Sapir
Lucee Core Developer
Lucee.org




--
Med venlig hilsen / Best regards
Poul Kristensen
Linux-OS/Virtualizationexpert and Oracle DBA

Re: [GENERAL] Postgresql and github

From
Nicklas Avén
Date:
On Thu, 2017-11-09 at 12:27 +0100, Poul Kristensen wrote:
Hi!

How come that Postgresql is not present in a github with latest release?

It would be very convenient to deploy PG using Ansible.

Oracle(latest release) is available through github.

TIA

Poul



How can you say Oracle is present on github?
In the link in your last post it clearly states that "You'll need to manually download the Oracle software and make it available to the control-machine (either locally or on a web-server, or through a nfs-share) before running the playbook."

As I understand it ansible is just some deployment automation?

PostgreSQL is available as binaries and sources from a lot of places, but Oracle is not, or am I missing something here?


Regards

Nicklas Avén

Re: [GENERAL] Postgresql and github

From
Steve Atkins
Date:
> On Nov 9, 2017, at 9:37 AM, Poul Kristensen <bcc5226@gmail.com> wrote:
>
> No it isn't.
>
> What I want to do is:
>
> ansible-playbook   somepostgresql.yml
>
> and postgresql is then changed on some server
> the way things are done by e.g.
> github.com/oravirt/ansible-oracle

You're looking for help with an Ansible recipe, not with anything to do with PostgreSQL itself.

Mentioning it here, in case someone already has one, is worth a try but you're likely going to need to go talk to the
Ansiblepeople. Or write your own. 

Cheers, Steve



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

Re: [GENERAL] Postgresql and github

From
Poul Kristensen
Date:
Dear friends,

The reason I posted this:

For the last 6 months I have noticed the enormous numbers of github's raising on the Internet. 
For the last 10 years I have worked with Oracle(yes expensive)and Postgresql(from version 8.4!) and I am familiar conserning the _big_
difference between the to database environments. Good and not so good. Administration well Oracle is easier because of
the instance/backup/restore(point in time) crontrolled by itselr.  Postgresql does not have that kind of stuff - I mean backup/restore(pointin time
controlled by _itself_. But it is free and free of charge. But is not 24/7 when upgrading. 
Therefore:
To make administration easier for your customers I suggest to establish a  github with different possibilites, showing how to upgrade minor/major
in 24/7 enviroments especially the restore(point in time) as a "build in" method liek Oracle'srman. I have been told by a consultant that 
pgBackRest is recommended. But it is not buildin in the way Oracle's rman. Sorry if i got out of the scope of my mail. And sorry for my demands.:)
BTW: why are PG databases visible by all users (prompt: \l)


Thanks 
Poul 







2017-11-09 19:00 GMT+01:00 Steve Atkins <steve@blighty.com>:

> On Nov 9, 2017, at 9:37 AM, Poul Kristensen <bcc5226@gmail.com> wrote:
>
> No it isn't.
>
> What I want to do is:
>
> ansible-playbook   somepostgresql.yml
>
> and postgresql is then changed on some server
> the way things are done by e.g.
> github.com/oravirt/ansible-oracle

You're looking for help with an Ansible recipe, not with anything to do with PostgreSQL itself.

Mentioning it here, in case someone already has one, is worth a try but you're likely going to need to go talk to the Ansible people. Or write your own.

Cheers,
  Steve



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



--
Med venlig hilsen / Best regards
Poul Kristensen
Linux-OS/Virtualizationexpert and Oracle DBA

Re: [GENERAL] Postgresql and github

From
Jeremy Schneider
Date:
Hi Poul, and thanks for using PostgreSQL!  I've also been a very heavy
user of Oracle and now a heavy user of PostgreSQL.

I remember the days before Oracle acquired the RMAN software and
bundled it with their database.  Not so long ago, doing backups on
Oracle wasn't so different from PostgreSQL; either you did
storage-level snapshots or you used sql to begin/end backup.  At that
time there were many 3rd party tools for managing Oracle backups, much
like the situation with PostgreSQL today.  You can write your own
scripts for backup and recovery, or if you want a polished interface
then you can use any of the free or commercial PostgreSQL backup and
recovery tools on the market.

PostgreSQL certainly does have the advanced 24/7 backup and
point-in-time recovery capabilities that you should expect in any
serious database.  I would also include 2nd Quadrant's "pglogical"
replication extension which enables near zero-downtime major version
upgrades, similar to what you might do with GoldenGate on Oracle.

Regarding ansible, the Oracle playbook you referenced was published by
Mikael Sandström from Sweden. He and I have both worked on the RAC
Attack project and I remember talking with him about those Ansible
scripts when he first published them! He's not an Oracle employee but
just a community contributor. There are also lots of people
contributing PostgreSQL roles in Ansible Galaxy (backed by GitHub).  I
see over 300 Ansible roles; does the link below work for you?

https://galaxy.ansible.com/list#/roles?page=1&page_size=10&autocomplete=postgres

You're certainly right that we could use more step-by-step examples
for new users to PostgreSQL.  As you continue learning, I hope you'll
continue to share what stands out to you.  You might even consider
writing some blog posts yourself - I would love to read them and pass
them along to other new users!  And if you find any errors in the
official PostgreSQL documentation, by all means let us know and we
will address them.

Looking forward to hearing more from you!

-Jeremy


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