Re: [SQL] check files .backup

2011-01-24 Thread Scott Marlowe
On Mon, Jan 24, 2011 at 5:18 PM, manuel antonio ochoa wrote: > Do you know if exist a  function to check my file.backup created by pgdump. I run backups like this in bash: if (pg_dump yadayada); then echo "backup succeeded." else echo "backup failed." fi; in a cronjob set to email me.

Re: [SQL] check files .backup

2011-01-24 Thread Craig Ringer
On 25/01/11 08:18, manuel antonio ochoa wrote: > Do you know if exist a function to check my file.backup created by > pgdump. ? What do you want to check? That it restores correctly? That it's complete and not truncated? That it hasn't been modified since being originally written? That it matches

[SQL] check files .backup

2011-01-24 Thread manuel antonio ochoa
Do you know if exist a function to check my file.backup created by pgdump. ? thnks

Re: [SQL] Postgres function for full text search

2011-01-24 Thread Ivan Sergio Borgonovo
On Mon, 24 Jan 2011 10:38:02 +0100 - wrote: > Hello everyone. > My question if any known one postgres function, for full text > search that separates words with "| "? > As plainto_tsquery separating words with "& ". > > For example text "word1 word2 word3 word4" > and conversion rates for full t

Re: [SQL] loosing data in postgres database

2011-01-24 Thread Piotr Czekalski
W dniu 2011-01-24 10:37, victor katemana pisze: hi everyone, i have a problem of loosing data in my postgres database whenever i restart my machine what could be the possible problem help me out? A plenty of reasons is possible, starting from uncommited transactions on shutdown till invalid fsy

Re: [SQL] loosing data in postgres database

2011-01-24 Thread Filip Rembiałkowski
2011/1/24 victor katemana : > hi everyone, i have a problem of loosing data in my postgres database > whenever i restart my machine what could be the possible problem help me > out? can you please adjust your question to this http://wiki.postgresql.org/wiki/Guide_to_reporting_problems How exactl

[SQL] Postgres function for full text search

2011-01-24 Thread -
Hello everyone. My question if any known one postgres function, for full text search that separates words with "| "? As plainto_tsquery separating words with "& ". For example text "word1 word2 word3 word4" and conversion rates for full text search postgres "word1 | word2 | word3 | word4" Or i mu

[SQL] loosing data in postgres database

2011-01-24 Thread victor katemana
hi everyone, i have a problem of loosing data in my postgres database whenever i restart my machine what could be the possible problem help me out?