Crie um arquivo com esse dados sem o _EOF_ como abaixo. Salve o arquivo.
execute o slonik << nome_do_arquivo_salvo. #-- # define the namespace the replication system uses in our example it is # slony_example #-- cluster name = $CLUSTERNAME; #-- # admin conninfo's are used by slonik to connect to the nodes one for each # node on each side of the cluster, the syntax is that of PQconnectdb in # the C-API # -- node 1 admin conninfo = 'dbname=$MASTERDBNAME host=$MASTERHOST user=$REPLICATIONUSER'; node 2 admin conninfo = 'dbname=$SLAVEDBNAME host=$SLAVEHOST user=$REPLICATIONUSER'; #-- # init the first node. Its id MUST be 1. This creates the schema # _$CLUSTERNAME containing all replication system specific database # objects. #-- init cluster ( id=1, comment = 'Master Node'); #-- # Slony-I organizes tables into sets. The smallest unit a node can # subscribe is a set. The following commands create one set containing # all 4 pgbench tables. The master or origin of the set is node 1. #-- create set (id=1, origin=1, comment='All pgbench tables'); set add table (set id=1, origin=1, id=1, fully qualified name = 'public.cliente', comment='Descrição cliente '); #-- # Create the second node (the slave) tell the 2 nodes how to connect to # each other and how they should listen for events. #-- store node (id=2, comment = 'Slave node'); store path (server = 1, client = 2, conninfo='dbname=$MASTERDBNAME host=$MASTERHOST user=$REPLICATIONUSER'); store path (server = 2, client = 1, conninfo='dbname=$SLAVEDBNAME host=$SLAVEHOST user=$REPLICATIONUSER'); store listen (origin=1, provider = 1, receiver =2); store listen (origin=2, provider = 2, receiver =1); Juan Garay escreveu: > Estou tentando fazer uma simples replicação. > > Eu seguir os passos descritos no tutorial: > http://www.vivaolinux.com.br/artigos/verArtigo.php?codigo=4536&pagina=3 > <http://www.vivaolinux.com.br/artigos/verArtigo.php?codigo=4536&pagina=3> > > mas está acontecendo o seguinte erro. <stdin>:39: ERROR: syntax error at > or near _EOF_ > > Por favor, quem souber, me de uma ajuda. > > > > o script e este aqui. a baixo.. > #!/bin/sh > > slonik <<_EOF_ > > #-- > > # define the namespace the replication system uses in our example it is > > # slony_example > > #-- > > cluster name = $CLUSTERNAME; > > #-- > > # admin conninfo's are used by slonik to connect to the nodes one for each > > # node on each side of the cluster, the syntax is that of PQconnectdb in > > # the C-API > > # -- > > node 1 admin conninfo = 'dbname=$MASTERDBNAME host=$MASTERHOST > user=$REPLICATIONUSER'; > > node 2 admin conninfo = 'dbname=$SLAVEDBNAME host=$SLAVEHOST > user=$REPLICATIONUSER'; > > #-- > > # init the first node. Its id MUST be 1. This creates the schema > > # _$CLUSTERNAME containing all replication system specific database > > # objects. > > #-- > > init cluster ( id=1, comment = 'Master Node'); > > #-- > > # Slony-I organizes tables into sets. The smallest unit a node can > > # subscribe is a set. The following commands create one set containing > > # all 4 pgbench tables. The master or origin of the set is node 1. > > #-- > > create set (id=1, origin=1, comment='All pgbench tables'); > > set add table (set id=1, origin=1, id=1, fully qualified name = > 'public.cliente', comment='Descrição cliente '); > > #-- > > # Create the second node (the slave) tell the 2 nodes how to connect to > > # each other and how they should listen for events. > > #-- > > store node (id=2, comment = 'Slave node'); > > store path (server = 1, client = 2, conninfo='dbname=$MASTERDBNAME > host=$MASTERHOST user=$REPLICATIONUSER'); > > store path (server = 2, client = 1, conninfo='dbname=$SLAVEDBNAME > host=$SLAVEHOST user=$REPLICATIONUSER'); > > store listen (origin=1, provider = 1, receiver =2); > > store listen (origin=2, provider = 2, receiver =1); > > _EOF_ > _______________________________________________ Grupo de Usuários do PostgreSQL no Brasil Antes de perguntar consulte o manual http://pgdocptbr.sourceforge.net/ Para editar suas opções ou sair da lista acesse a página da lista em: http://pgfoundry.org/mailman/listinfo/brasil-usuarios
