[ADMIN] postgres access errors

2000-03-18 Thread steve doerr
Hi everyone, I'm new at postgres and I am trying to run a shell script to create a db for a java app. All I can seem to get are one of the three following errors no matter what I try. User not in pg_shadow (when I just created the user as super and with the ability to create databases). Serial

Re: [ADMIN] Advantages of pg_dumpall over tar/gzip?

2000-03-18 Thread Bruce Momjian
> What's the advantage of using pg_dumpall over tar/gzip for backup? pg_dumpall grabs a constent snapshot of the data. tar/gzip is just backing up the files, so you can get some data in some table that is committed, but miss data in another table that is part of the same transaction. Of course,

Re: [ADMIN] lower/upper case

2000-03-18 Thread Peter Eisentraut
On Fri, 17 Mar 2000, J Carlos Morales Duarte. wrote: > > > select * from books where titulo like '%perl%'; > > select * from books where titulo like '%Perl%'; > > > in This querys, postgres return diferents registers, but i need return > the same registers... what i doing? select * from boo

[ADMIN] Advantages of pg_dumpall over tar/gzip?

2000-03-18 Thread thomas
What's the advantage of using pg_dumpall over tar/gzip for backup?