Re: [ADMIN] hi group,,

http://www.postgresql.org/docs/8.0/interactive/backup.html http://www.postgresql.org/docs/8.0/interactive/app-pgdump.html http://www.postgresql.org/docs/8.0/interactive/app-pgrestore.html On 07.10.2005 04:32, shailesh gavavthe wrote: Am Shail,,Newbie to the group.. using postgreSQL 8.0.. Its wor

[ADMIN] horology test failed

Guys,   I was installing Postgresql 8.0.4 on  SuSE Linux 9.1 (x86-64) and kernel 2.6.5-7.201-default   below is the config command i ran ./configure --prefix="/usr/local/pgsql8.0.4" --datadir="/home/postgres/data8.0.4" --with-pgport="8000" --enable-thread-safety gmake gmake check . test horolog

Re: [ADMIN] create table like syntax

David Durham wrote: > is there a syntax that would look something like: > > create table newTable like oldTable without indexes || records || > constraints with indexes || records || constraints > > built into postgres? > Try this: create table newTable as select * from oldTable limit 0;

Re: [ADMIN] horology test failed

I found the problem. I made a mistake in the ./configure command. the new command is ./configure --prefix="/usr/local/pgsql8.0.4" --with-pgport="8000" --enable-thread-safety   after gmake check == All 96 tests passed.==  And all works fine :)   gourish singba

Re: [ADMIN] create table like syntax

Alvaro Herrera wrote: On Wed, Oct 05, 2005 at 10:04:10PM -0500, David Durham wrote: is there a syntax that would look something like: create table newTable like oldTable without indexes || records || constraints with indexes || records || constraints built into postgres? What do you w

[ADMIN] How do I unsubscribe?

tried 3 or 4 times and no luc k. lori ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

[ADMIN] How to check for pg_dump errors?

Silly question, but in a shell script, what is the best way to check for a pg_dump problem?  I'm working on reworking our backup methodology, and want to make sure that if pg_dump can't dump a db, we page the on call db.  Does it return any sort of exit code indicating it was not successful dumping

Re: [ADMIN] How to check for pg_dump errors?

Chris Hoover <[EMAIL PROTECTED]> writes: > Silly question, but in a shell script, what is the best way to check for a > pg_dump problem? I'm working on reworking our backup methodology, and want > to make sure that if pg_dump can't dump a db, we page the on call db. Does > it return any sort of exi

Re: [ADMIN] How to check for pg_dump errors?

Am Freitag, 7. Oktober 2005 22:13 schrieb Chris Hoover: > Silly question, but in a shell script, what is the best way to check for a > pg_dump problem? 0 is success, nonzero is failure. ---(end of broadcast)--- TIP 9: In versions below 8.0, the plan

Re: [ADMIN] How do I unsubscribe?

See the email headers... List-Unsubscribe: On Fri, Oct 07, 2005 at 08:16:20AM -0700, lorid wrote: > tried 3 or 4 times and no luc k. > > lori > > ---(end of broadcast)--- > TIP 2: Don't 'kill -9' the postmaster > --

Re: [ADMIN] How do I unsubscribe?

Thanks , got it. lori Jim C. Nasby wrote: See the email headers... List-Unsubscribe: On Fri, Oct 07, 2005 at 08:16:20AM -0700, lorid wrote: tried 3 or 4 times and no luc k. lori ---(end of broadcast)--- TIP 2: D