On 5/15/19 5:29 PM, Julie Nishimura wrote:
Guys, thank you everybody who tried to solve this mystery! It is solved
now. I went through the logs and found those "alter database" commands,
based on host and time, I've just found shell script which was executing
from crontab and setting all databa
nes and control) default_tablespace to
the emptiest volume...
Thanks everybody...
From: Adrian Klaver
Sent: Wednesday, May 15, 2019 3:35 PM
To: Julie Nishimura; David G. Johnston
Cc: pgsql-general@lists.postgresql.org
Subject: Re: default_tablespace in 8.3 postgresql
On 5/15/19 3:28 PM, Julie Nishimura wrote:
Nope, I did not...
pg_roles only shows "rolconfig" as {default_transaction_read_only=true}
for some users...
The only other commands I ran between creation of tablespace and alter
dbs are:
grant all on tablespace vol4 to public;
grant create on ta
to public;
From: Adrian Klaver
Sent: Wednesday, May 15, 2019 3:22 PM
To: Julie Nishimura; David G. Johnston
Cc: pgsql-general@lists.postgresql.org
Subject: Re: default_tablespace in 8.3 postgresql
On 5/15/19 3:01 PM, Julie Nishimura wrote:
> No, I did not have them at all in my scri
licitly...
Sigh
From: David G. Johnston
<mailto:david.g.johns...@gmail.com>
Sent: Wednesday, May 15, 2019 1:23 PM
To: Julie Nishimura
Cc: Adrian Klaver;
pgsql-general@lists.postgresql.org<mailto:pgsql-general@lists.postgresql.org>
Subject: Re: default_tablespace in 8.3 postgresql
On 5/15/19 3:01 PM, Julie Nishimura wrote:
No, I did not have them at all in my script. I did not touch neither
these three dbs, nor like some others that I did not intend to alter,
but they are altered regardless. Or unless this is what pg_database
reports back to me... What is even more inter
that makes sense, thanks!
From: Adrian Klaver
Sent: Wednesday, May 15, 2019 3:15 PM
To: Julie Nishimura; David G. Johnston
Cc: pgsql-general@lists.postgresql.org
Subject: Re: default_tablespace in 8.3 postgresql
On 5/15/19 3:01 PM, Julie Nishimura wrote:
> No
... I dont have any other good explanations...
*From:* Adrian Klaver
*Sent:* Wednesday, May 15, 2019 2:18 PM
*To:* Julie Nishimura; David G. Johnston
*Cc:* pgsql-general@lists.postgresql.org
*Subject:* Re: default_tablespace in
From: Adrian Klaver
Sent: Wednesday, May 15, 2019 2:48 PM
To: Julie Nishimura; David G. Johnston
Cc: pgsql-general@lists.postgresql.org
Subject: Re: default_tablespace in 8.3 postgresql
On 5/15/19 2:45 PM, Julie Nishimura wrote:
> Adrian, only first 3 (which are template0, postgres, control). Re
planations...
*From:* Adrian Klaver
*Sent:* Wednesday, May 15, 2019 2:18 PM
*To:* Julie Nishimura; David G. Johnston
*Cc:* pgsql-general@lists.postgresql.org
*Subject:* Re: default_tablespace in 8.3 postgresql
On 5/15/19 2:15 PM, Julie
as created with the explicit
tablespace in it?... I dont have any other good explanations...
From: Adrian Klaver
Sent: Wednesday, May 15, 2019 2:18 PM
To: Julie Nishimura; David G. Johnston
Cc: pgsql-general@lists.postgresql.org
Subject: Re: default_tablesp
On 5/15/19 2:15 PM, Julie Nishimura wrote:
Sure, thank you guys!
CREATE TABLESPACE vol4
OWNER postgres
LOCATION '/data/vol4';
ALTER DATABASE tables_ericb
SET default_tablespace = 'vol4';
ALTER DATABASE conversion_feasibility_too
SET default_tablespace = 'vol4';
... and so on for 60 dbs
60 dbs...
but not for all 70+
From: Adrian Klaver
Sent: Wednesday, May 15, 2019 2:11 PM
To: Julie Nishimura; David G. Johnston
Cc: pgsql-general@lists.postgresql.org
Subject: Re: default_tablespace in 8.3 postgresql
On 5/15/19 1:57 PM, Julie Nishimura wrote:
> This puzzles me too!
g
*Subject:* Re: default_tablespace in 8.3 postgresql
On Wed, May 15, 2019 at 1:01 PM Julie Nishimura <mailto:juliez...@hotmail.com>> wrote:
However, since I have modified template1 (and most likely, those
databases were copied from it in the past), it changed
default_parameter
Johnston
*Sent:* Wednesday, May 15, 2019 1:23 PM
*To:* Julie Nishimura
*Cc:* Adrian Klaver; pgsql-general@lists.postgresql.org
*Subject:* Re: default_tablespace in 8.3 postgresql
On Wed, May 15, 2019 at 1:01 PM Julie Nishimura <mailto:juliez...@hotmail.com>> wrote:
However, since I have modi
Wednesday, May 15, 2019 1:23 PM
To: Julie Nishimura
Cc: Adrian Klaver; pgsql-general@lists.postgresql.org
Subject: Re: default_tablespace in 8.3 postgresql
On Wed, May 15, 2019 at 1:01 PM Julie Nishimura
mailto:juliez...@hotmail.com>> wrote:
However, since I have modified template1 (a
Adrian Klaver
*Sent:* Wednesday, May 15, 2019 12:47 PM
*To:* Julie Nishimura; pgsql-general@lists.postgresql.org; pgsql-general
*Subject:* Re: default_tablespace in 8.3 postgresql
On 5/15/19 12:39 PM, Julie Nishimura wrote:
Hello, I have created new tablespace on a new drive yesterday and
modif
On Wed, May 15, 2019 at 1:01 PM Julie Nishimura
wrote:
> However, since I have modified template1 (and most likely, those databases
> were copied from it in the past), it changed default_parameter for them as
> well.
>
This seems unlikely to be the case - changing template1 should not be
affecti
, May 15, 2019 12:47 PM
To: Julie Nishimura; pgsql-general@lists.postgresql.org; pgsql-general
Subject: Re: default_tablespace in 8.3 postgresql
On 5/15/19 12:39 PM, Julie Nishimura wrote:
> Hello, I have created new tablespace on a new drive yesterday and
> modified some of existing databases
On 5/15/19 12:39 PM, Julie Nishimura wrote:
Hello, I have created new tablespace on a new drive yesterday and
modified some of existing databases to use this tablespace as default,
like this:
ALTER DATABASE xxx
SET default_tablespace = 'vol4';
So, this command did not physically move any exist
20 matches
Mail list logo
