On 5/13/19 5:56 PM, Julie Nishimura wrote:
er_temp=# select * from pg_tables where tablename = 'test';
schemaname | tablename | tableowner | tablespace | hasindexes |
hasrules | hastriggers
+---++++--+-
public |
| f | f| f
(1 row)
From: Adrian Klaver
Sent: Monday, May 13, 2019 5:52 PM
To: Julie Nishimura; pgsql-general@lists.postgresql.org; pgsql-general
Subject: Re: does postgresql backup require additional space on disk
On 5/13/19 5:39 PM, Julie Nishi
On 5/13/19 5:39 PM, Julie Nishimura wrote:
LOL. Adrian, I so appreciate your help.
So, since this server is obviously very old, and it seems like 3 other
tablespaces were added in the past (vol1 - 2.7 tb, vol2 - 2.7 tb, vol3 -
16 tb), and I am about to add another vol - vol4 (4 tb), I am tryin
___
From: Adrian Klaver
Sent: Monday, May 13, 2019 5:09 PM
To: Julie Nishimura; pgsql-general@lists.postgresql.org; pgsql-general
Subject: Re: does postgresql backup require additional space on disk
On 5/13/19 4:53 PM, Julie Nishimura wrote:
> Adrian,
> I t
rative properties ...
www.postgresonline.com <http://www.postgresonline.com>
*From:* Adrian Klaver
*Sent:* Monday, May 13, 2019 2:47 PM
*To:* Julie Nishimura; pgsql-general@lists.postgresql.org; pgsql-general
*Subject:* Re
.
Then "default" part got lost in emails...:)
From: Adrian Klaver
Sent: Monday, May 13, 2019 4:33 PM
To: Julie Nishimura; pgsql-general@lists.postgresql.org; pgsql-general
Subject: Re: does postgresql backup require additional space on disk
On 5/13/19 3:27 PM, Jul
sonline.com
*From:* Adrian Klaver
*Sent:* Monday, May 13, 2019 2:47 PM
*To:* Julie Nishimura; pgsql-general@lists.postgresql.org; pgsql-general
*Subject:* Re: does postgresql backup require additional space on disk
On 5/13/19 1:26 PM, Julie Nishimura wro
rian Klaver
Sent: Monday, May 13, 2019 2:47 PM
To: Julie Nishimura; pgsql-general@lists.postgresql.org; pgsql-general
Subject: Re: does postgresql backup require additional space on disk
On 5/13/19 1:26 PM, Julie Nishimura wrote:
> Adrian, thanks for your reply. Couple of clarifications/question
On 5/13/19 1:26 PM, Julie Nishimura wrote:
Adrian, thanks for your reply. Couple of clarifications/questions:
1) we are on 8.3 for this server
8.3 does not have ALTER DATABASE name SET TABLESPACE :
https://www.postgresql.org/docs/8.3/sql-alterdatabase.html
It does appear until 8.4.
2) I was
yeah, good idea. Thanks everybody
From: karsten.hilb...@gmx.net on behalf of Karsten
Hilbert
Sent: Monday, May 13, 2019 2:12 PM
To: pgsql-general@lists.postgresql.org
Subject: Re: does postgresql backup require additional space on disk
On Mon, May 13, 2019 at
On Mon, May 13, 2019 at 07:33:58PM +, Julie Nishimura wrote:
> We have added new disk volume and about to introduce new
> tablespace using this additional disk space. After that, I am
> going to alter all user dbs (and template db as well) by
> runnig the following command:
>
> CREATE TABLESPA
re?
Thanks,
Julie
*From:* Adrian Klaver
*Sent:* Monday, May 13, 2019 1:10 PM
*To:* Julie Nishimura; pgsql-general@lists.postgresql.org; pgsql-general
*Subject:* Re: does postgresql backup require additional space on disk
-
> *From:* Adrian Klaver
> *Sent:* Monday, May 13, 2019 11:19 AM
> *To:* Julie Nishimura; pgsql-general@lists.postgresql.org; pgsql-general
> *Subject:* Re: does postgresql backup require additional space on disk
> On 5/13/19 10:59 AM, Julie Nishimura wrote:
>>
al
*Subject:* Re: does postgresql backup require additional space on disk
On 5/13/19 10:59 AM, Julie Nishimura wrote:
Hello,
we are almost out of disk space on one of our servers (99% full). If we
run pg_dump to a diff location, does it require any additional disk
space on our current server? I am as
13, 2019 11:19 AM
To: Julie Nishimura; pgsql-general@lists.postgresql.org; pgsql-general
Subject: Re: does postgresql backup require additional space on disk
On 5/13/19 10:59 AM, Julie Nishimura wrote:
> Hello,
> we are almost out of disk space on one of our servers (99% full). If we
> r
On 5/13/19 10:59 AM, Julie Nishimura wrote:
Hello,
we are almost out of disk space on one of our servers (99% full). If we
run pg_dump to a diff location, does it require any additional disk
space on our current server? I am asking, because on some other
software, a backup might open transacti
Hello,
we are almost out of disk space on one of our servers (99% full). If we run
pg_dump to a diff location, does it require any additional disk space on our
current server? I am asking, because on some other software, a backup might
open transaction which keeps growing and eventually consume
17 matches
Mail list logo
