Re: [ADMIN] 8.2.15 pitr/00000001.history

Ray Stell wrote: > On Wed, Mar 24, 2010 at 01:10:31PM -0400, Ray Stell wrote: > > 2010-03-24 12:38:36.357 EDT,,3,,, LOG: restore_command = "cp > > /home/postgresql/fms/wals/%f %p" > >cp: cannot stat `/home/postgresql/fms/wals/0001.history': No such > > file or directory > > patience, y

Re: [ADMIN] 8.2.15 pitr/00000001.history

On Wed, Mar 24, 2010 at 01:10:31PM -0400, Ray Stell wrote: > 2010-03-24 12:38:36.357 EDT,,3,,, LOG: restore_command = "cp > /home/postgresql/fms/wals/%f %p" >cp: cannot stat `/home/postgresql/fms/wals/0001.history': No such file > or directory patience, young padawan: 2010-03-24 12:38

Re: [ADMIN] How to use an alias name in the current select

Hi, Guy Deleeuw writes: >SELECT > t_orders_articles.k_idAS k_id > ,t_orders_articles.quantityAS order_qty > ,(SELECT sum(quantity) FROM t_deliveries_articles WHERE article_id = > t_orders_articles.k_id) AS delivery_qty > , (t_orders_article

[ADMIN] 8.2.15 pitr/00000001.history

While testing an 8.2.15 pitr procedure I see this postmaster log entry on startup of the recovered cluster: 2010-03-24 12:38:36.357 EDT,,3,,, LOG: restore_command = "cp /home/postgresql/fms/wals/%f %p" cp: cannot stat `/home/postgresql/fms/wals/0001.history': No such file or directory

[ADMIN] How to use an alias name in the current select

Hello I have : SELECT t_orders_articles.k_idAS k_id ,t_orders_articles.quantityAS order_qty ,(SELECT sum(quantity) FROM t_deliveries_articles WHERE article_id = t_orders_articles.k_id) AS delivery_qty , (t_orders_articles.quantity - delive

Re: [ADMIN] Backup&Restore Postgres DB

Hi Scott, I m real new in this so be patient :) I check in postgres and: radius-# \l List of databases Name| Owner | Encoding ---+--+-- postgres | postgres | UTF8 radius| postgres | UTF8 root | postgres | UTF8 template0 | postgres | UTF8