Re: [GENERAL] database files are incompatible with server, after computer restart

2006-08-29 Thread CSN
--- Douglas McNaught <[EMAIL PROTECTED]> wrote: > CSN <[EMAIL PROTECTED]> writes: > > > I'm stymied. ;) > > So you've tried running both pg_ctl binaries against the data > directory and both don't work? Yes. > I wonder how you ever had a database > working in that case. :) Me too! After 'i

Re: [GENERAL] database files are incompatible with server, after computer restart

2006-08-29 Thread CSN
--- Douglas McNaught <[EMAIL PROTECTED]> wrote: > CSN <[EMAIL PROTECTED]> writes: > > > I don't know which to run now! I tried both > > '/opt/local/lib/pgsql8/bin/pg_ctl start -D pgdata' > and > > You might want an absolute path for 'pgdata' > here--have you tried > that? ~ $ /opt/local/lib/pg

Re: [GENERAL] database files are incompatible with server, after

2006-08-29 Thread Douglas McNaught
CSN <[EMAIL PROTECTED]> writes: > I don't know which to run now! I tried both > '/opt/local/lib/pgsql8/bin/pg_ctl start -D pgdata' and You might want an absolute path for 'pgdata' here--have you tried that? > putting /opt/local/lib/pgsql8/bin before > /usr/local/bin in PATH and still get the sa

Re: [GENERAL] database files are incompatible with server, after computer restart

2006-08-29 Thread CSN
--- Douglas McNaught <[EMAIL PROTECTED]> wrote: > CSN <[EMAIL PROTECTED]> writes: > > > I don't think so -- I followed the instructions > here: > > > > > http://www.robbyonrails.com/articles/2006/05/29/install-ruby-rails-and-postgresql-on-osx > > > > But looking around, I see there's a pg_ctl in

Re: [GENERAL] database files are incompatible with server, after

2006-08-29 Thread Douglas McNaught
CSN <[EMAIL PROTECTED]> writes: > I don't think so -- I followed the instructions here: > > http://www.robbyonrails.com/articles/2006/05/29/install-ruby-rails-and-postgresql-on-osx > > But looking around, I see there's a pg_ctl in > /usr/local/bin, but 'port contents postgresql8' shows > a pg_ctl

Re: [GENERAL] database files are incompatible with server, after computer restart

2006-08-28 Thread CSN
I don't think so -- I followed the instructions here: http://www.robbyonrails.com/articles/2006/05/29/install-ruby-rails-and-postgresql-on-osx But looking around, I see there's a pg_ctl in /usr/local/bin, but 'port contents postgresql8' shows a pg_ctl in /opt/local/lib/pgsql8/bin. ~ $ ll /opt/lo

Re: [GENERAL] database files are incompatible with server, after

2006-08-28 Thread Douglas McNaught
CSN <[EMAIL PROTECTED]> writes: > DETAIL: The database cluster was initialized without > HAVE_INT64_TIMESTAMP but the server was compiled with > HAVE_INT64_TIMESTAMP. > HINT: It looks like you need to recompile or initdb. Is it possible you have two PG installs on this machine, and you're tryin

[GENERAL] database files are incompatible with server, after computer restart

2006-08-28 Thread CSN
I installed and started PostgreSQL and it worked fine for days. Then I restarted my computer and now I can't start PostgreSQL ('pg_ctl -D pgdata -l pgdata/psql.log start'). Here's what's in my log: LOG: received immediate shutdown request WARNING: terminating connection because of crash of anoth

Re: [GENERAL] database files

2003-10-23 Thread Christopher Browne
[EMAIL PROTECTED] (Gail Zacharias) wrote: > I am investigating the possibility of using pgsql as the database in > an application. I have some unusual requirements that I'd like to > ask you all about. I apologize in advance if my terminology is a > little "off", I'm not familiar with pgsql (yet)

Re: [GENERAL] database files

2003-10-23 Thread scott.marlowe
On Wed, 22 Oct 2003, Gail Zacharias wrote: > I need to be able to move the database files, as normal user-visible > files, between machines. I.e. given a database on machine A, I want to > be able to copy either a single file (ideally) or a single directory > (less ideal but still ok) to, say,

Re: [GENERAL] database files

2003-10-23 Thread Alvaro Herrera
> On 22/10/2003 20:41 Gail Zacharias wrote: > > >I need to be able to move the database files, as normal user-visible > >files, between machines. I.e. given a database on machine A, I want to be > >able to copy either a single file (ideally) or a single directory (less > >ideal but still ok) to, sa

Re: [GENERAL] database files

2003-10-22 Thread Dann Corbit
> -Original Message- > From: Gail Zacharias [mailto:[EMAIL PROTECTED] > Sent: Wednesday, October 22, 2003 12:42 PM > To: [EMAIL PROTECTED] > Subject: [GENERAL] database files > > > I am investigating the possibility of using pgsql as the > database in a

[GENERAL] database files

2003-10-22 Thread Gail Zacharias
I am investigating the possibility of using pgsql as the database in an application. I have some unusual requirements that I'd like to ask you all about. I apologize in advance if my terminology is a little "off", I'm not familiar with pgsql (yet). I need to be able to move the database files,

Re: [GENERAL] database files

2003-10-22 Thread Tom Lane
[EMAIL PROTECTED] writes: > Gail Zacharias <[EMAIL PROTECTED]> writes: >> Is the file format of the pgsql database files compatible between >> OS's? E.g. could I take some database files from Linux and use them >> on Windows? > I don't know the answer to that, but I would be interested in finding

Re: [GENERAL] database files

2003-10-22 Thread jearl
Gail Zacharias <[EMAIL PROTECTED]> writes: > I am investigating the possibility of using pgsql as the database in > an application. I have some unusual requirements that I'd like to > ask you all about. I apologize in advance if my terminology is a > little "off", I'm not familiar with pgsql (ye