Re: UDD migration to ullmann.debian.org

[Andreas Tille <andreas@an3as.eu>]

Hi ullmann admins,

thanks a lot for this very good news!  This helps a lot.

I wonder whether we could now find a way to export the UDD bugs
tables as I have suggested and which was confirmed by Lucas:

   http://lists.debian.org/debian-qa/2012/05/msg00023.html

I do see two options:

   1. Either generate the partial database dump in a cron
      job and move it to some http-accessible space or
   2. Get a passwordless sshkey which has the only single
      permission to trigger the dump and rsync the result
      (=call a dedicated scipt)

What would your prefered solution to make a a dump of a few UDD tables
accessible to some other host?

Kind regards and thanks for your great work

      Andreas.

On Mon, Jun 25, 2012 at 08:07:38PM +0100, Stephen Gran wrote:
> This one time, at band camp, Lucas Nussbaum said:
> > [dsa] setup password-less guest access on ullmann (currently broken, asks
> >   for password)
> > [dsa] add service=udd entry on ullmann
> 
> sgran@ullmann:~$ psql -U guest 'service=udd'
> psql (9.1.4)
> SSL connection (cipher: DHE-RSA-AES256-SHA, bits: 256)
> Type "help" for help.
> 
> udd=> 
> 
> > [dsa] tune PG (with pgtune?)
> 
> Done.
> 
> Let us know when it's time to move the tunnels around.
> 
> Cheers,
> -- 
>  -----------------------------------------------------------------
> |   ,''`.                                            Stephen Gran |
> |  : :' :                                        sgran@debian.org |
> |  `. `'                        Debian user, admin, and developer |
> |    `-                                     http://www.debian.org |
>  -----------------------------------------------------------------



-- 
http://fam-tille.de