is a temp solution due to space constarints in '/var' on a test box.
Isn't meant to be an operational solution!
On Wed, Feb 11, 2009 at 8:29 PM, Dan Colish dcol...@gmail.com wrote:
out of sheer morbid curiosity, why are you creating a tablespace owned by
the _postgresql daemon user under
Dear List,
in a 4.4 box with Postgresql 8.3.3 I try to create a new tablespace in a
different filesystem and get the following error:
---
template1=# CREATE TABLESPACE tbspace-name OWNER DB-user LOCATION
'/home/DB-user/db';
ERROR: could not set
On Wed, Feb 11, 2009 at 03:59:53PM +0100, Tony Berth wrote:
Dear List,
in a 4.4 box with Postgresql 8.3.3 I try to create a new tablespace in a
different filesystem and get the following error:
---
template1=# CREATE TABLESPACE tbspace-name
On 11 February 2009 c. 17:59:53 Tony Berth wrote:
Dear List,
in a 4.4 box with Postgresql 8.3.3 I try to create a new tablespace in
a different filesystem and get the following error:
---
template1=# CREATE TABLESPACE tbspace-name OWNER DB-user
On Wed, Feb 11, 2009 at 4:13 PM, Jason Dixon ja...@dixongroup.net wrote:
On Wed, Feb 11, 2009 at 03:59:53PM +0100, Tony Berth wrote:
Dear List,
in a 4.4 box with Postgresql 8.3.3 I try to create a new tablespace in a
different filesystem and get the following error:
On Wed, Feb 11, 2009 at 05:07:45PM +0100, Tony Berth wrote:
On Wed, Feb 11, 2009 at 4:13 PM, Jason Dixon ja...@dixongroup.net wrote:
On Wed, Feb 11, 2009 at 03:59:53PM +0100, Tony Berth wrote:
Dear List,
in a 4.4 box with Postgresql 8.3.3 I try to create a new tablespace in a
On Wed, Feb 11, 2009 at 5:17 PM, Jason Dixon ja...@dixongroup.net wrote:
On Wed, Feb 11, 2009 at 05:07:45PM +0100, Tony Berth wrote:
On Wed, Feb 11, 2009 at 4:13 PM, Jason Dixon ja...@dixongroup.net
wrote:
On Wed, Feb 11, 2009 at 03:59:53PM +0100, Tony Berth wrote:
Dear List,
On Wed, Feb 11, 2009 at 05:24:41PM +0100, Tony Berth wrote:
On Wed, Feb 11, 2009 at 5:17 PM, Jason Dixon ja...@dixongroup.net wrote:
On Wed, Feb 11, 2009 at 05:07:45PM +0100, Tony Berth wrote:
On Wed, Feb 11, 2009 at 4:13 PM, Jason Dixon ja...@dixongroup.net
wrote:
On Wed, Feb 11,
Apologies, for the typo, its postgresql not postgres, although it can work
with either.
On Wed, Feb 11, 2009 at 5:31 PM, Jason Dixon ja...@dixongroup.net wrote:
On Wed, Feb 11, 2009 at 05:24:41PM +0100, Tony Berth wrote:
On Wed, Feb 11, 2009 at 5:17 PM, Jason Dixon ja...@dixongroup.net
wrote:
On Wed, Feb 11, 2009 at 05:07:45PM +0100, Tony Berth wrote:
On Wed, Feb 11,
I did the following:
- as '_postgresql' UNIX user I issued psql -d template1 postgres
- then issued twice the CREATE TABLESPACE cmd as already described and got
the error (with OWNER defined both 'postgres' and 'DB-user')
that's all I did!
Thanks
Tony
You should have a read of
On Wed, Feb 11, 2009 at 05:46:28PM +0100, Tony Berth wrote:
case#1:
my /home/DB-user/db dir is owned by _postgresql:_postgresql
Wow, you've managed to completely ignore all advice both Dan Colish and
myself have given you. Since you continue to refuse to do any of these
things, or give me
Obviously you're doing something wrong. But you're not showing us your
commands or the errors, so we're not going to be much help.
I did the following:
- as '_postgresql' UNIX user I issued psql -d template1 postgres
- then issued twice the CREATE TABLESPACE cmd as already described and
learn to create users or http://www.ubuntu.com/getubuntu/download
On Wed, Feb 11, 2009 at 5:38 PM, Tony Berth tonybe...@googlemail.comwrote:
On Wed, Feb 11, 2009 at 5:31 PM, Jason Dixon ja...@dixongroup.net wrote:
On Wed, Feb 11, 2009 at 05:24:41PM +0100, Tony Berth wrote:
On Wed, Feb 11, 2009 at 5:17 PM, Jason Dixon ja...@dixongroup.net
wrote:
On
On Wed, Feb 11, 2009 at 5:51 PM, Jason Dixon ja...@dixongroup.net wrote:
On Wed, Feb 11, 2009 at 05:46:28PM +0100, Tony Berth wrote:
case#1:
my /home/DB-user/db dir is owned by _postgresql:_postgresql
Wow, you've managed to completely ignore all advice both Dan Colish and
myself have
Tony Berth wrote:
On Wed, Feb 11, 2009 at 5:51 PM, Jason Dixon ja...@dixongroup.net wrote:
On Wed, Feb 11, 2009 at 05:46:28PM +0100, Tony Berth wrote:
case#1:
my /home/DB-user/db dir is owned by _postgresql:_postgresql
Wow, you've managed to completely ignore all advice both Dan Colish and
On Wed, Feb 11, 2009 at 7:23 PM, Alexander Hall alexan...@beard.se wrote:
Tony Berth wrote:
On Wed, Feb 11, 2009 at 5:51 PM, Jason Dixon ja...@dixongroup.net
wrote:
On Wed, Feb 11, 2009 at 05:46:28PM +0100, Tony Berth wrote:
case#1:
my /home/DB-user/db dir is owned by
Tony Berth wrote:
On Wed, Feb 11, 2009 at 7:23 PM, Alexander Hall alexan...@beard.se wrote:
Tony Berth wrote:
On Wed, Feb 11, 2009 at 5:51 PM, Jason Dixon ja...@dixongroup.net
wrote:
On Wed, Feb 11, 2009 at 05:46:28PM +0100, Tony Berth wrote:
case#1:
my /home/DB-user/db dir is owned by
On Wed, Feb 11, 2009 at 7:48 PM, Alexander Hall alexan...@beard.se wrote:
Tony Berth wrote:
On Wed, Feb 11, 2009 at 7:23 PM, Alexander Hall alexan...@beard.se
wrote:
Tony Berth wrote:
On Wed, Feb 11, 2009 at 5:51 PM, Jason Dixon ja...@dixongroup.net
wrote:
On Wed, Feb 11, 2009 at
On Wed, Feb 11, 2009 at 7:48 PM, Alexander Hall alexan...@beard.se wrote:
Tony Berth wrote:
On Wed, Feb 11, 2009 at 7:23 PM, Alexander Hall alexan...@beard.se
wrote:
Tony Berth wrote:
On Wed, Feb 11, 2009 at 5:51 PM, Jason Dixon ja...@dixongroup.net
wrote:
On Wed, Feb 11, 2009 at
On Wed, Feb 11, 2009 at 07:56:36PM +0100, Tony Berth wrote:
very simple! Instead of '_postgresql' it was '_potgresql'! It was one 's'
missing! I had a rather small font defined for my terminals connected to the
And do you see how much time/frustration would have been saved if you
would have
On Wed, Feb 11, 2009 at 8:11 PM, Jason Dixon ja...@dixongroup.net wrote:
On Wed, Feb 11, 2009 at 07:56:36PM +0100, Tony Berth wrote:
very simple! Instead of '_postgresql' it was '_potgresql'! It was one 's'
missing! I had a rather small font defined for my terminals connected to
the
And
out of sheer morbid curiosity, why are you creating a tablespace owned by
the _postgresql daemon user under /home?
24 matches
Mail list logo