Hey,
Is there anyway to limit a database size?
For example, I need to create a database for user X and I don't want it to
use more than 5 GB.
On Wed, Sep 28, 2016 at 1:39 PM, Adir Shaban wrote:
> Hey,
>
> Is there anyway to limit a database size?
Nope.
check this
https://www.postgresql.org/message-id/619537.42270.qm%40web53708.mail.re2.yahoo.com
thread.
Regards,
Amul
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.
Adir Shaban wrote:
> Is there anyway to limit a database size?
> For example, I need to create a database for user X and I don't want it to
> use more than 5 GB.
You can create a tablespace on a device with limited size.
Then you can create the database on that tablespace.
Yours,
Laurenz Albe
-
Maybe your are after IS NOT DISTINCT FROM NULL
https://www.postgresql.org/docs/current/static/functions-comparison.html
Albe Laurenz writes:
> Adir Shaban wrote:
>> Is there anyway to limit a database size?
>> For example, I need to create a database for user X and I don't want it to
>> use more than 5 GB.
> You can create a tablespace on a device with limited size.
> Then you can create the database on that tabl
From: Pavel StehuleSent: Tuesday, September 27, 2016 9:18 PM
2016-09-28 6:13 GMT+02:00 Pavel Stehule mailto:pavel.steh...@gmail.com> >:
Hi
2016-09-27 23:03 GMT+02:00 Mike Sofen mailto:mso...@runbox.com> >:
Hi gang,
how to view the state of a transaction in flight, seeing how many rows have
So how did heroku limit the database size per user?
I thought about creating triggers on insert and updates but that will lead
to bad performance
On Wed, Sep 28, 2016, 15:31 Tom Lane wrote:
> Albe Laurenz writes:
> > Adir Shaban wrote:
> >> Is there anyway to limit a database size?
> >> For exa
2016-09-28 14:34 GMT+02:00 Mike Sofen :
> *From:* Pavel Stehule*Sent:* Tuesday, September 27, 2016 9:18 PM
> 2016-09-28 6:13 GMT+02:00 Pavel Stehule :
>
> Hi
>
> 2016-09-27 23:03 GMT+02:00 Mike Sofen :
>
> Hi gang,
>
> how to view the state of a transaction in flight, seeing how many rows
> ha
On 09/27/2016 01:10 PM, dudedoe01 wrote:
Thanks Kevin, Igor and Adrian. In MySQL with the isnull() function I get all
three values RPG INV, Owner Inventory, and Builder Inventory showed up in
the view while when I do the is null function in postgreSQL I only see
Builder Inventory and Owner Invent
dudedoe01 schrieb am 27.09.2016 um 19:04:
> I am trying to emulate the isnull() function used in MySQL into postreSQL. I
> have tried different ways such is null but it's not producing the results
> desired. I am doing a data migration from MySQL into postgreSQL and need
> help with the isnull() in
On Tue, Sep 27, 2016 at 3:12 PM, dudedoe01 wrote:
> The tables I migrated from MySQL into postgreSQL have exactly the same amount
> of rows of data so the problem is inside the view being created.
Have you actually confirmed that there are any cases where
isnull(expression) yields a different res
Does anybody know a Software for generating graphical entity relation models
from existing postgresql databases?
Best regards Johannes
On Wed, Sep 28, 2016 at 4:17 PM, jotpe wrote:
> Does anybody know a Software for generating graphical entity relation
> models from existing postgresql databases?
>
>
My personal favorites (in order):
schemaspy.sf.net
https://www.dbvis.com/
http://www.sqlpower.ca/page/architect
> Best regards J
I need to add a new column to my largest table, something like:
alter table foo add column col_15 text not null default 'foobar';
I am tempted to add the column as NULL, and then use coalesce and nullif in
the client code to re-interpret NULL as being the value 'foobar'. But I
think that that wo
From: jotpe Sent: Wednesday, September 28, 2016 1:17 PM
Does anybody know a Software for generating graphical entity relation models
from existing postgresql databases?
Best regards Johannes
---
I don’t know any useful free ones, but my favorite less expensive one (and the
one I’ve use
On 29/09/16 05:47, jotpe wrote:
Does anybody know a Software for generating graphical entity relation models
from existing postgresql databases?
Best regards Johannes
I like SchemaSpy.
--
=
Stephen Davies Consulting P
On 09/26/2016 09:05 PM, Michael Paquier wrote:
What are the files in pg_xlog/archive_status? Do see a lot of .ready
entries? Perhaps you could de-bloat things by using archive_command =
'/bin/true' (REM on Windows as far as I recall).
There is no archive_status
ll 9.3/main/pg_xlog/ |grep arc
On Thu, Sep 29, 2016 at 2:25 PM, Francisco Reyes wrote:
> There is no archive_status
>
> ll 9.3/main/pg_xlog/ |grep arch
> postgres@s0pdb03:~$
Meh. There must be a folder named archive_status in pg_xlog. Or
something is broken with your installation. Don't you have in your log
files something li
18 matches
Mail list logo
