Hi all,
I have following script to backup database:
- cut --
#!/bin/sh
PSQL=/usr/local/pgsql/bin/psql
DUMP=/usr/local/pgsql/bin/pg_dump
PREFIX=`date +%j`
BACKUP_DIR=/usr/local/pgsql/data/base/.BACKUP
Databases=`$PSQL -tq -d template1 -c "select datname from pg_database"`
renice
On Wed, 19 Aug 1998, Przemyslaw Bak wrote:
> Hi all,
>
> I have following script to backup database:
> - cut --
> #!/bin/sh
>
> PSQL=/usr/local/pgsql/bin/psql
> DUMP=/usr/local/pgsql/bin/pg_dump
> PREFIX=`date +%j`
> BACKUP_DIR=/usr/local/pgsql/data/base/.BACKUP
>
> Databases=
> Preface:
> ===
>
> Well, finally, we have decided to start backing up the Postgres databases
> we have. And the decision even came before anything got destroyed...
>
> So, our sysadmin basically made a modified version of the dumpall script,
> that creates individual files for each databas
> At 17:51 +0300 on 19/8/98, Bruce Momjian wrote:
>
>
> > I believe this was fixed in the coming 6.4 beta, September 1.
>
> Ah, I see... now, where did I put that time machine... :)
>
> Well, I thought I'd do a pg_dump -S and append the normal pg_dump to it.
> Thus, the schema will be created
Preface:
===
Well, finally, we have decided to start backing up the Postgres databases
we have. And the decision even came before anything got destroyed...
So, our sysadmin basically made a modified version of the dumpall script,
that creates individual files for each database, which include
At 17:51 +0300 on 19/8/98, Bruce Momjian wrote:
> I believe this was fixed in the coming 6.4 beta, September 1.
Ah, I see... now, where did I put that time machine... :)
Well, I thought I'd do a pg_dump -S and append the normal pg_dump to it.
Thus, the schema will be created twice, and whateve
I want to create a simple auto increment field
starting at for example.
How do I do this in postgres?
Thanks
-jeremy
