Re: [SQL] Database Transfer

2000-06-19 Thread Kate Collins 

I have an interest in this topic ...

I am looking to do "real time" updates of a data base on two different
servers, with one acting as a master and the other acting as a slave.  In
the realm of Oracle, I believe it is called "replication".

>From what I have read, there is no such feature in pgsql.  Can somebody
confirm this?

Thanks,
Kate Collins

Peter Eisentraut wrote:

> Craig May writes:
>
> > I have two servers running pgsql.  Is there a command to transfer the
> > databases
> > between them?
>
> pg_dump and psql. "Back up" one database and "restore" it on the other
> server. Don't even think about moving files around. :)
>
> --
> Peter Eisentraut  Sernanders väg 10:115
> [EMAIL PROTECTED]   75262 Uppsala
> http://yi.org/peter-e/Sweden

--
=
Katherine (Kate) L. Collins
Senior Software Engineer/Meteorologist
Weather Services International (WSI Corporation)
4 Federal Street
Billerica, MA 01821
EMAIL:  [EMAIL PROTECTED]
PHONE: (978) 670-5110
FAX: (978) 670-5100
http://www.intellicast.com

[SQL] the day after...

2000-06-19 Thread Tulassay Zsolt 


hi,
our linux box crashed yesterday, and postgresql seems to have some
trouble with one of the databases. It says:

zsolt@tek:/var/lib/pgsql$ psql tek
Connection to database 'tek' failed.
FATAL 1:  cannot create init file pg_internal.init


All other databases are working just fine.
Any idea?

Thanks,
Zsolt


PS: this mailing list is probably not the appropriate one
for such a question, but this is the one i'm subscribed
to, so please forgive me this time... :-)

Re: [SQL] the day after...

2000-06-19 Thread Tom Lane 

Tulassay Zsolt <[EMAIL PROTECTED]> writes:
> FATAL 1:  cannot create init file pg_internal.init

Hmm, disk full?  Wrong ownership or permissions on database
directory (data/base/tek)?

Looks like that error report needs to include the kernel
error message...

regards, tom lane

[SQL] SQL92 and Traditional

2000-06-19 Thread Toshihide Nakamura 

Hello,

I have a question.  I am seeing lots of SQL92-compared-to-Traditional-SQL.
What is a definition of "Traditional"?  Is it SQL89? 86?  Or anything
before 92?  It seems like postgresql supports both, but which is it better
to write?  

Thanks,


Tony