If it were me, I'd probably do something like (my id is not root, but I can
use sudo to run something as root)
sudo mv -vn /var/lib/pgsql/data /var/lib/pgsql/data-old
sudo su - postgres #change to user postgres
initdb
pg_ctl start
exit #exit back to my id, from being postgres
If you need to, afte
On 01/07/2014 09:11 AM, Susan Cassidy wrote:
I ran an initdb, but got a message that the Encoding I specified was
invalid, so I tried to run it again, and now I get:
initdb: directory "/var/lib/pgsql/data" exists but is not empty
If you want to create a new database system, either remove or empt
I ran an initdb, but got a message that the Encoding I specified was
invalid, so I tried to run it again, and now I get:
initdb: directory "/var/lib/pgsql/data" exists but is not empty
If you want to create a new database system, either remove or empty
the directory "/var/lib/pgsql/data" or run in
Hello,
When doing the setup for a benchmark of pgsql on an High IO instance of
Amazon, I got the following problem and was wondering if it is expected:
On FreeBSD 9.0 amd64, I installed PostgreSQL 9.1.5 on the boot drive (UFS),
created a ZFS pool using the 2 SSD drives (tank/db), chown pgsql tank
Thank for the good input.
I found my problem. I compiled initially *with* the --disable-rpath
option. When I realised my mistake, I did a make uninstall,
reconfigured, rebuilt, and reinstalled. My post was made when I had
done this and thought I had the settings as stated. However, the
uninstall d
Hello Chris,
can not provide much help.
But definitely the message sounds like case (1) (8.3 server accessing
7.4 files)
I did encounter such with two occasions:
a) used an old initdb version
b) using an rc script that had hard coded path to the (old) data directory
both cases seem not to appl
Chris McCormick writes:
> Because of issues with dump/restore, I am instead setting up a
> second cluster under a newer version so I can slowly migrate data (I
> have 7.4.30, and am adding 8.3.18 on the same box). The problem is
> that when I try to start the new postmaster it complains:
> "F
Hello all,
Because of issues with dump/restore, I am instead setting up a
second cluster under a newer version so I can slowly migrate data (I
have 7.4.30, and am adding 8.3.18 on the same box). The problem is
that when I try to start the new postmaster it complains:
"FATAL: database files ar
On Tue, Oct 19, 2010 at 08:48:13AM +0200, Torsten Zühlsdorff wrote:
> Thom Brown schrieb:
>
> >initdb creates a database cluster, not a database. [..]
>
> Now i'm feeling like fool - this is so obviously. -.- I will stop
> posting stressed to the Usenet.
Yay, an NNTP user :)
We've all been the
Thom Brown schrieb:
initdb creates a database cluster, not a database. [..]
Now i'm feeling like fool - this is so obviously. -.- I will stop
posting stressed to the Usenet.
I'm sorry. Thanks for your replies and time!
Greetings,
Torsten
--
http://www.dddbl.de - ein Datenbank-Layer, der
In response to Tom Lane :
> Adrian Klaver writes:
> > On Monday 18 October 2010 7:46:21 am Torsten Z_hlsdorff wrote:
> >> So: any idea why the database is not visible? And how do get rid of the
> >> "non-existing" databases ;)
>
> > My guess is that you have more than one installation of Postgre
Adrian Klaver writes:
> On Monday 18 October 2010 7:46:21 am Torsten Zühlsdorff wrote:
>> So: any idea why the database is not visible? And how do get rid of the
>> "non-existing" databases ;)
> My guess is that you have more than one installation of Postgres. The initdb
> is
> working on one c
On Monday 18 October 2010 7:46:21 am Torsten Zühlsdorff wrote:
> Hello,
>
> i'm using initdb of an PostgreSQL 8.4 installed over the port-system of
> FreeBSD:
>
> =
>
> > initdb foo --locale=de_DE.UTF-8 --lc-collate=de_DE.UTF-8
>
> --lc-ctype=de_DE.UTF-8 --lc-messages=de_DE.UTF-8
> --lc-moneta
On 18 October 2010 15:46, Torsten Zühlsdorff wrote:
> Hello,
>
> i'm using initdb of an PostgreSQL 8.4 installed over the port-system of
> FreeBSD:
>
> =
>
>> initdb foo --locale=de_DE.UTF-8 --lc-collate=de_DE.UTF-8
>> --lc-ctype=de_DE.UTF-8 --lc-messages=de_DE.UTF-8 --lc-monetary=de_DE.UTF-8
Hello,
i'm using initdb of an PostgreSQL 8.4 installed over the port-system of
FreeBSD:
=
> initdb foo --locale=de_DE.UTF-8 --lc-collate=de_DE.UTF-8
--lc-ctype=de_DE.UTF-8 --lc-messages=de_DE.UTF-8
--lc-monetary=de_DE.UTF-8 --lc-numeric=de_DE.UTF-8 --lc-time=de_DE.UTF-8
The files belon
I have compiled beta5 on linux_sparc...(Sun ULTRA1)
but initdb returns error...
Error: unknown type 'oid8'
...
I compiled with configuration...
--with-template=linux_sparc
--enable-locale
--enable-multibyte=LATIN2
--with-odbc
--with-perl
--with-tcl
What's wrong?
--Greg--
16 matches
Mail list logo
