Re: Production Database requirement

[Michelle Konzack]

Salam Mohammed,

Am DATE hackte Azimuddin Mohammed in die Tasten:
> Hello All,
> Can anyone please let me know
>
> 1. What is the hardware and software  requirement for postgressql to be
> installed in production. We are planning to use postgres for hadoop
> backend, to store user access info, metadata etc. So, it will not be high
> transaction db, but we might see lost of reads to this db.

It sound a only a little bit more what I have a s /etc/passwd, /etc/shadow,
/etc/groups and /etc/gshadow replacement...

I have exactly this too and it rund quiert well on a MiniITX with 1000MHz
and 1 GByte of memory which is 60% unused.  The Debian GNU/Linux 7.11
installation together with the postgresql database using less then
5 GByte...  Lets say, the whole thing would run an a 20 GByte HDD.

I manage currently 23.000 users with it...

And no, I do not use LDAP.

My webservices authenticate directly with the database server which is
hostet at a friendly ISP in Estonia.

> 2. Can we use Vm's to run the Db? Is it recommended ?

Yes of course.

> Thanks in Advance!



-- 
Michelle Konzack
00372-54541400

Re: Production Database requirement

[Vincenzo Romano]

2018-01-04 18:47 GMT+01:00 Azimuddin Mohammed :
> Hello All,
> Can anyone please let me know
>
> 1. What is the hardware and software  requirement for postgressql to be
> installed in production. We are planning to use postgres for hadoop backend,
> to store user access info, metadata etc. So, it will not be high transaction
> db, but we might see lost of reads to this db.

Your question makes little sense without any details about the data
and the application architecture.
Please elaborate more.
You'd elaborate more on these points in order to get some meaningful advise.

> 2. Can we use Vm's to run the Db? Is it recommended ?

There's nothing against virtualization apart the computing and I/O
limits it can pose.
In general, real hardware can provide for better performances.

> Thanks in Advance!
>
>
> --
>
> Regards,
> Azim
>
>
> Virus-free. www.avast.com



-- 
Vincenzo Romano - NotOrAnd.IT
Information Technologies
--
NON QVIETIS MARIBVS NAVTA PERITVS

Re: Production Database requirement

[Francis Santiago]

2018-01-04 14:47 GMT-03:00 Azimuddin Mohammed :

> Hello All,
> Can anyone please let me know
>
> 1. What is the hardware and software  requirement for postgressql to be
> installed in production. We are planning to use postgres for hadoop
> backend, to store user access info, metadata etc. So, it will not be high
> transaction db, but we might see lost of reads to this db.
>

the minimum requirements depend of use the your bds, you can start by 50GB
y,  memory 2 Gb, for example

>
> 2. Can we use Vm's to run the Db? Is it recommended ?
>

Yes, they can use VM'S

>
>
> Thanks in Advance!
>
>
> --
>
> Regards,
> Azim
>
>
>
> 
>  Virus-free.
> www.avast.com
> 
> <#m_2540529285869011783_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
>