cancel
Showing results for 
Search instead for 
Did you mean: 

[Webinar] Installing Postgres on Linux

Community Manager

[Webinar] Installing Postgres on Linux

 

The Pulse of Postgres Slim.png

 

Coming Soon: Installing Postgres on Linux
With Marc Linster and Devrim Gündüz
 

Date: September 11, 2019
Time: 10.00am ET | 16.00 CET | 15.00 GMT

Join Postgres experts Marc Linster and Devrim Gündüz as they provide a step by step guide for installing PostgreSQL and EDB Postgres Advanced Server on Linux.

Highlights include:

  • The advantages of native packages
  • An in-depth look at RPMs and DEBs
  • A step by step demo

This webinar is the first of a short series that explores installation on Linux (September 11th, 2019), Containers (September 25, 2019), and Windows (October 9, 2019).

REGISTER NOW

Interested in the webcast but not able to attend the live event? Register anyway and we’ll send you the recording shortly after the webcast. 
 
About the Speakers:

Image_Mark_Circle.png

Marc Linster, SVP, Product Development & Support

Devrim Gunduz Headshot.png

Devrim Gündüz, Principal Systems Engineer

1 REPLY 1
Community Manager

Re: [Webinar] Installing Postgres on Linux

Follow Up: [WEBINAR]  Installing Postgres on Linux

 

We hope you had a chance to join us for the webinar!!   If not, don't worry! 

You can view the webinar via the link below. Be sure to check out the Q & A Session too!

 

 

Q & A SESSION:

__________________

 

Question:

Can data created in EDB10 be accessed by EDB11? Or vice versa?

 

Answer:

No. To use v10 data with v11, you need to run pg_upgrade. The reverse option is not available.

 

_____

 

Question:

Can I have two different versions of Postgres running on the same server?

 

Answer:

Yes. Just use different port numbers.

 

_____

 

Question:

Can we use PEM on Community PostgreSQL?

 

Answer:

Yes.

 

_____

 

Question:

Can EDB advanced server be sold as a lifetime license?

 

Answer:

Please contact us to discuss your needs.

 

_____

 

Question:

Does EDB have a lifetime license then subscribe for the support and renew it yearly?

 

Answer:

Please contact us to discuss your needs.

 

_____

 

Question:

1. We are at Debian 7, must we upgrade to Debian 9 to install v 11.5?

2. May we install v 10.10 on Debian 7?

 

Answer:

We only support Debian 9 at the moment.

 

_____

 

Question:

Do you have a webinar on upgrading to a major version for postgres and EDB?

 

Answer:

We will add this to the list of topics for the Pulse of Postgres.

 

_____

 

Question:

What happens when software demo time limit expires?

 

Answer:

The software is fully functional, however, you will be in breach of the license agreement. Please contact us if you need an extended trial license.

 

_____

 

Question:

Does postgres recommend any particular type of storage as best practice? 

 

Answer:

SAN and/or DAS. We don't recommend NAS, iSCSI, etc.

 

_____

 

Question:

Can we have a webinar on setting up Kerberos auth in Postgres using windows AD... There is no proper documentation anywhere online for this topic and it is an important topic. Thank you so much.

 

Answer:

We will add this to the list of topics for the Pulse of Postgres.

 

_____

 

Question:

What version of postgres does PL/SQL support start at?

 

Answer:

All supported EPAS versions have PL/SQL support. Use v11 for the best experience.

 

_____

 

Question:

Does initdb need to be run as root user?

 

Answer:

RPM script must be run as the root user, but it switches to EnterpriseDB user during actual initdb. Root execution of the actual initdb command is not permitted.

 

_____

 

Question:

What are WAL files?

 

Answer:

They are the transaction logs of Postgres.

 

_____

 

Question:

How can I update minor versions if there is no internet connection from Linux server? We go through a satellite server.

 

Answer:

Just download the new tarball which includes updated RPMs, and upload them to Satellite.

 

_____

 

Question:

I want to install without access to YUM. Can I download all RPMs?

 

Answer:

Yes. https://yum.enterprisedb.com provides tarballs of the RPMs.

 

_____

 

Question:

Any best practice for database file separation?

 

Answer:

We recommend separate disks for WAL and data files. Having separate drives for indexes is a bonus.

 

_____

 

Question:

Please give also a demo of installing EDB Postgres on a server WITHOUT network access.

 

Answer:

We will add this to the list of topics for the Pulse of Postgres.

 

_____

 

Question:

What will happen to the installation after the evaluation period expires?

 

Answer:

EPAS will continue running, but using it will be a breach of the licence agreement.

 

_____

 

Question:

Can you show how to install 2 postgres instances using two different users and two different ports on one host?  

 

Answer:

We will add this to the list of topics for the Pulse of Postgres.

 

_____

 

Question:

Do you have a template for creating systemctl scripts if I'd like run two postgres clusters on one host?

 

Answer:

Just create copies of the unit file under /etc/system.d/system with different names, and edit them.

 

_____

 

Question:

Is it possible to get BART and EFM for only testing purposes?

 

Answer:

Yes.

 

_____

 

Question:

To confirm, initdb doesn't allow us to create cluster in custom directory?

 

Answer:

If you want to do it with the script that RPM provides, just create a custom unit file.

 

_____

 

Question:

How do you change the default location for the install?

 

Answer:

It is not possible for the binaries/libraries, because RPMs are not relocatable. However, you can customize the data directory. See unit file for details.

 

_____