工具使我们的PostgreSQL开发服务器和生产服务器同步
资 源 简 介
pgdbsync allows us to track the differences in the database structure between different databases. It also create the needed script to synchronize the servers and even to run the script.
The usage of pgdbsync command line script is the following one:
-c [schema] -f [from database] -t [to database] -a [action: diff | summary | run]
usage examples
* Summary
```
./pgdbsync -s web -f devel -t prod -a summary
HOST : production :: prod1
--------------------------------------------
function
create :: WEB.hello(varchar)
tables
create :: WEB.test
view
create :: WEB.testview
[OK] end process
```
Creating diff script
```
./pgdbsync -s wf -f devel -t prod -a diff
HOST : production :: prod1
--------------------------------------------
CREATE OR REPLACE FUNCTION web.hello(item character varying)
RETURNS character varying
LANGUAGE plpgsql
AS $function$
DECLARE
BEGIN
return "Hi " || item;
END;
$function$
CREATE TABLE web.
文 件 列 表
pgdbsync
cli
.hg
conf.ini
example1.php
lib
