Hi,
If this is not the correct place report this type thing please let me
know and I will post it to the correct location. I was able to
successfully alter a column of type date to varchar(20). However now
when I perform selects on the table I will either get the results as
expected, have the p
unsubscribe pgsql-bugs
Do you Yahoo!?vote.yahoo.com - Register online to vote today!
unsubscribe pgsql-admin
Do you Yahoo!?vote.yahoo.com - Register online to vote today!
unsubscribe pgsql-admin
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
unsubscribe pgsql-bugs
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
>Goulet, Dick
> As an Oracle DBA primarily, moving more towards PostGreSQL as time
> passes, the "alter system switch logfile" command is very often used at
> the end of a hot backup to force a logfile switch and consequently
> provide a full archive log set. The command causes the database engine
> pg_restore -U admin -C -d staging /home/postgres/staging-dump
pg_restore: [archiver (db)] could not execute query: ERROR: database
"staging" already exists
-C tells it to create (and then connect to) the target DB, rather than
connect to an existing DB and restore into that. So generally you
Dan Hrabarchuk <[EMAIL PROTECTED]> writes:
> Is there a FAQ or a HOWTO on recovering from database corruption? If
> not, then I am willing to write it. I will need help getting the
> document together because as much as I google, I come up empty handed.
> ...
> I want to have something that can be
Is there a FAQ or a HOWTO on recovering from database corruption? If
not, then I am willing to write it. I will need help getting the
document together because as much as I google, I come up empty handed.
What I need is something that tells you:
A> You get errors in your server log like:
Hi,
I am in the process of migrating PG cidr and network address
type functions to Oracle, and
am wondering if anyone has done similar work before.
Specifically, I want to know how to map cidr to Oracle type
(varchar2(18)) ?
How to convert operator like:
inet
'192.168.1.5' << i
[EMAIL PROTECTED] writes:
> pg_restore -U admin -c /home/postgres/staging-dump
> Now, although tons of data is now streaming to my monitor, when it is
> done, none of the new data is in the backup's staging db.
The default behavior of pg_restore is to emit SQL commands onto stdout,
which of cour
On Thu, Oct 07, 2004 at 10:32:04AM -0400, Goulet, Dick scratched on the wall:
> Some disk array manufacturers had a problem with their writes in that
> although the write the data was being stored in volatile memory instead
> of on disk. The disk buffers were volatile in that if power suddenly
>
Some disk array manufacturers had a problem with their writes in that
although the write the data was being stored in volatile memory instead
of on disk. The disk buffers were volatile in that if power suddenly
died all writes in memory that had not made it to disk were lost.
Lately most array ma
Hello list,
I am having problems getting pg_dump and pg_restore to work the way
they are supposed to work - or at least the way I imagine they should work!
I have a primary DB server, and a backup DB server. The point is to
use pg_dump
every 5 minutes to have the current postgeSQL db available on
On Oct 1, 2004, at 10:12, Tore Halset wrote:
I am running 8.0.0-beta3 on Mac OS X 10.3.5 and 8.0.0-beta2-dev3
(pginstaller) on windows 2000. I have two databases. The dumpfile
(format c) for database 1 is 150MB and the dumpfile for database 2 is
2GB.
Dumping the databases on the mac worked. I h
Goulet, Dick wrote:
As an Oracle DBA primarily, moving more towards PostGreSQL as time
passes, the "alter system switch logfile" command is very often used at
the end of a hot backup to force a logfile switch and consequently
provide a full archive log set. The command causes the database engine
16 matches
Mail list logo
