Capacity Planning

[bhargav kamineni]

Hi Team,


What are the check lists for doing capacity planning for a postgresql
server ?

Regards,
BK.

Re: the installation of pgadmin4 makes me weep in frustration

[Tony Shelver]

I know this has already been answered, but for those who are also python
users, there is another and probably better option:

If you already have a python 3.6+ installation, you can download the
pgadmin4 wheel (python installable) from https://www.pgadmin.org/download/

Then do a pip install on it as for any other python module.

I prefer this route as it avoids having multiple python versions loaded on
my machine.

The standard install for the current version of pgadmin4 will download
python along with it.

As far as other tools go, I prefer to design my database using a modeling
tool.

As the only database we use or will use is postgresql, I find
https://pgmodeler.io to be pretty good for e free(ish) product.
It provides support for many postgres-only features such as extensions,
functions, json/jsonb and so on
And for a new python user, the product manual (contribution required) is an
excellent source for postgres-specific design topics.



On Mon, 14 Jan 2019 at 15:49, Murtuza Zabuawala <
murtuza.zabuaw...@enterprisedb.com> wrote:

> Thanks to Postgres Debian/Ubuntu packaging team, Installing pgAdmin4 is
> straightforward task,
>
> 1) Create the file /etc/apt/sources.list.d/pgdg.list and add a line for
> the repository
> deb http://apt.postgresql.org/pub/repos/apt/ bionic-pgdg main
>
> 2) Import the repository signing key, and update the package lists
> wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc |
> sudo apt-key add -
>
> 3) sudo apt-get update
>
> 4) sudo apt-get install pgadmin4
>
> Check https://www.postgresql.org/download/linux/ubuntu/ for more
> information.
>
> --
> Regards,
> Murtuza Zabuawala
> EnterpriseDB: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>
>
>
> On Mon, Jan 14, 2019 at 1:29 PM robert  wrote:
>
>> Hi There
>>
>>
>> first, thanks a lot for the great an beautiful software we get from
>> PostgreSQL and all people around it.
>>
>> But I wonder how it comes, that installing pgadmin4 is so incredibly hard?
>>
>> And no documentation.
>>
>> I would like to install pgadmin4 to my ubuntu 18.1 laptop.
>>
>> Where do I find doku on how to install pgadmin4. Preferably I would like
>> to install it using pip?
>>
>>
>> thanks
>>
>> robert
>> --
>> Robert Rottermann CEO
>>
>> 031 333 10 20
>> rob...@redo2oo.ch
>> Sickingerstrasse 3, 3014 Bern
>> 
>>
>> [image: https://Redo2oo.ch] 
>> *Ihr Partner wenn es um ERP Lösungen geht.*
>>
>

Re: Capacity Planning

[Allan Kamau]

Some of the aspects you may want to consider are:
1) Per unit time (day or week), how much data will be persisted to the
database, number of records and total size of the data.
2) How much of these data will be updated and how frequently in a given
time unit (day or week).
3) Will the databases hosted on the server be for OLTP (OnLine
Transactional Processing) or OLAP (OnLine Analytical Processing) or a
combination of the two.
4) In case of hardware failure or electrical outage or outage due to other
factors including human activity, how much loss of data (and time) can be
tolerated, see "https://www.postgresql.org/docs/11/backup.html"; and "
https://www.postgresql.org/docs/11/high-availability.html";.
5) The size of the budget for hardware and manpower.

Allan.

On Sat, Jan 19, 2019 at 1:38 PM bhargav kamineni  wrote:

> Hi Team,
>
>
> What are the check lists for doing capacity planning for a postgresql
> server ?
>
> Regards,
> BK.
>