SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-09-2008, 11:13 PM
| ||||
| ||||
 Re: WAL shipping question > Im trying to play a bit with log shipping between 2 servers primary and standby. These servers are running versions 8.3betat3. I had set up continuous archiving at the primary server. The manuals' example of archive_command is > archive_command = 'cp -i %p /mnt/server/archivedir/%f </dev/null' > > This basically archives the data in the primary server itself...right!!! > But how can I set up continuous archiving from primary to a directory (WAL archive directory) > on the stand-by server ? >>a. Mount the remote directory via NFS/SMBFS/... >>b. Use a remote copy, e.g. scp, FTP... Thanks... I tried this command to both copy in the primary server and scp to standby server. archive_command = 'cp -i "%p" .../archivedir/"%f" && scp -B "%p".../archivedir/"%f" "%p" user@172.31.0.21:/....archivedir/"%f"' cp works but scp doesnt work. Is it becoz scp generally asks for password. I can do scp or ssh without password authentication but Im not sure if it is safe to do that. What is the alternative for getting this done? Thanks sharmila __________________________________________________ __________________________________ Be a better pen pal. Text or chat with friends inside Yahoo! Mail. See how. http://overview.mail.yahoo.com/      |
|
04-09-2008, 11:13 PM
| ||||
| ||||
| Re: WAL shipping question SHARMILA JOTHIRAJAH wrote: >> Im trying to play a bit with log shipping between 2 servers primary > and standby. These servers are running versions 8.3betat3. I had set up > continuous archiving at the primary server. The manuals' example of > archive_command is >> archive_command = 'cp -i %p /mnt/server/archivedir/%f </dev/null' >> >> This basically archives the data in the primary server > itself...right!!! >> But how can I set up continuous archiving from primary to a directory > (WAL archive directory) >> on the stand-by server ? > >>> a. Mount the remote directory via NFS/SMBFS/... >>> b. Use a remote copy, e.g. scp, FTP... > > > Thanks... > I tried this command to both copy in the primary server and scp to standby server. > > archive_command = 'cp -i "%p" .../archivedir/"%f" && > scp -B "%p".../archivedir/"%f" "%p" user@172.31.0.21:/....archivedir/"%f"' > > cp works but scp doesnt work. Is it becoz scp generally asks for password. I can do scp or ssh without password authentication but Im not sure if it is safe to do that. > > What is the alternative for getting this done? You can generate a public/private key pair on the database server and store the public version in ~/.ssh/authorized_keys on the remote server. Google for details. -- Richard Huxton Archonet Ltd ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly |
Linear Mode
