hyelluas writes:
> I want to create a tablespace from a command line.
> I created the directory and set chmod to 0700 , still could not do it.
> [root@Prof20_52_91 data]# chmod 0700 /data/psql/my_test1
... that says "psql" ...
> postgres=# create tablespace my_test1 OWNER postgres location
> '/
On Fri, Mar 25, 2011 at 7:10 PM, hyelluas wrote:
> [root@Prof20_52_91 data]# ls -ltr psql
> postgres=# create tablespace my_test1 OWNER postgres location
> '/data/pgsql/my_test1';
> ERROR: could not set permissions on directory "/data/pgsql/my_test1": No
> such file or directory
When you say '
Hello,
I want to create a tablespace from a command line.
I created the directory and set chmod to 0700 , still could not do it.
I can create a tablespace from Admin GUI, not from psql
I'm using PostgreSQL 8.4.6 on RedHat 5.4
[root@Prof20_52_91 data]# ls -ltr psql
total 12
drwx-- 7 postgres
Hi Willy and Raghu,
I rebuild from source code with kerberos/gssapi support, and changed to use
'gss' authentication method, it works now :)!
Thanks very much for your kindly help.
Regards,
Yandong
From: raghu ram mailto:raghuchenn...@gmail.com>>
Date: Thu, 24 Mar 2011 11:09:33 -0400
To: Will
Greetings!
I want to install the Postgres ODBC driver version 8.04 for a customer
that is currently using 8.01. However, I cannot make any change to the
customer's computer without being able to undo the change in case
something goes wrong. The customer has a spare computer that we have
been
On Thu, Mar 24, 2011 at 1:43 PM, raghu ram wrote:
>
>
> On Thu, Mar 24, 2011 at 6:09 PM, Stevie wrote:
>>
>> Hello pgsql-admins,
>>
>> we have a problem with our Postgresql 9.0.3 backup database (Ubuntu 10.4).
>> The backup and restore is done as described here:
>> http://www.postgresql.org/docs/
Hello
> There is a commit log corruption in your database.
Yes, and it seems this is produce by a pg_upgrade bug from pg8 to pg9 in
October 2010.
> You need to make the files with right size (256K of zeroes).A suitable
> "dd" from /dev/zero will accomplish this on modernUnixen (ie, anything
> t
