7.3.4 - pg_relcheck

Поиск
Список
Период
Сортировка
Искать

7.3.4 - pg_relcheck

От:
Rudi Starcevic <rudi@oasis.net.au>
Дата:
Hi,

I'm migrating an application from 7.2 to 7.3.4 and a small error has 
poped up.
One of the pieces of software that uses PG for this app. is ColdFusion 5.0
A propriety piece of  from Macromedia.

So far it's all OK and running fine but I did see error when creating a 
table without a Primary key
that complained about pg_relcheck not being there.

So I thought I'd write just to double check that pg_relcheck has been 
dropped and it's not just me.
Pg_relcheck is no longer in the system tables is it ?

Many thanks
Regards
Rudi.




Re: 7.3.4 - pg_relcheck

От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
Rudi Starcevic  writes:
> So I thought I'd write just to double check that pg_relcheck has been 
> dropped and it's not just me.
> Pg_relcheck is no longer in the system tables is it ?

pg_relcheck has been replaced by a more general table, pg_constraint.
Sounds like ColdFusion needs an update.

			regards, tom lane

ERserver patch question

От:
Kris Kiger <kris@musicrebellion.com>
Дата:
Has anyone installed the ant_buildfile_upgrade for ERServer?  I haven't 
been able to find install instructions or figure it out since, for some 
reason, the patch appears to be in XML.  Any ideas?  Thanks for the help

Kris




Re: ERserver patch question

От:
Andrew Sullivan <andrew@libertyrms.info>
Дата:
On Wed, Oct 15, 2003 at 09:14:09AM -0500, Kris Kiger wrote:
> Has anyone installed the ant_buildfile_upgrade for ERServer?  I haven't 
> been able to find install instructions or figure it out since, for some 
> reason, the patch appears to be in XML.  Any ideas?  Thanks for the help

I haven't had the time to patch and check that everything builds
correctly (sorry, everyone), so I haven't applied it to the CVS
system.  But it _is_ in XML, because that's how Ant buildfiles are
written.  I'm not exactly sure what the patch is supposed to do, BTW. 
The program all builds for me.

A

-- 
----
Andrew Sullivan                         204-4141 Yonge Street
Afilias Canada                        Toronto, Ontario Canada
                              M2P 2A8
                                         +1 416 646 3304 x110

ERserver problems

От:
Kris Kiger <kris@musicrebellion.com>
Дата:
I have two databases set up, one designated as a master (w/database 
named masterdb) and one designated as a slave (w/ database named 
slavedb).  My problem is that the two are inexplicably not replicating. 
 First, I checked the replication.cfg files on each machine to verify 
that the master and slave information was correctly set, it was.  Next, 
I verified that there was no problem making a connection between the two 
databases.  So, i'm concluding that there must have been some sort of 
ERServer configuration error made.  I setup the master server with 
ers_setup and respective params and the following tables/sequences were 
created inside of the masterdb:

 public | _rserv_active_log_id_      | sequence | erserv
 public | _rserv_log_1_                   | table    | erserv
 public | _rserv_log_2_                   | table    | erserv
 public | _rserv_old_log_status_     | sequence | erserv
 public | _rserv_servers_                 | table    | erserv
 public | _rserv_servers__server_seq | sequence | erserv
 public | _rserv_sync_                     | table    | erserv
 public | _rserv_sync_seq_              | sequence | erserv
 public | _rserv_tables_                   | table    | erserv

Next, I created the slave using ers_addslave, with respective params, 
and the following tables were created in slavedb:

 public | _rserv_slave_sync_        | table    | erserv
 public | _rserv_slave_tables_      | table    | erserv

I created one table, testrep1(test_id int, description text), on both 
the master server and slave server and then ran ers_addtable 
--table=testrep1 on the masterserver.  According the PostgreSQL Inc.'s 
documentation, this command should propogate this information through 
the master and slave servers.  ERserver created its unique key 
(_ers_uniq) and appended it to the master server table, however, the 
slavedb's testrep1 was not changed.  I restarted both ERservers using 
ers_stop and then ers_start and then began inserting data into the 
masterdb's testrep1.  The unique sequence was being iterated and 
everything appeared to be working successfully, however, no action is 
ever performed on the slave database.  In fact, both erserver tables 
created on slavedb were never written to (no reference of testrep1). 
 Any ideas?  Any help is much appreciated!

Kris

Re: ERserver problems

От:
Andrew Sullivan <andrew@libertyrms.info>
Дата:

On Mon, Oct 20, 2003 at 11:43:00AM -0500, Kris Kiger wrote:
> I have two databases set up, one designated as a master (w/database 
> named masterdb) and one designated as a slave (w/ database named 
> slavedb).  My problem is that the two are inexplicably not replicating. 

Please see the archives for the mailing list for erserver.  They're
available at the erserver gborg site.  In short, there is a bug in
the setup scripts, and you need to do some work by hand. 
Instructions are in the archives.

A

-- 
----
Andrew Sullivan                         204-4141 Yonge Street
Afilias Canada                        Toronto, Ontario Canada
                              M2P 2A8
                                         +1 416 646 3304 x110

FAQ