On Wed, Jun 22, 2005 at 04:02:24PM -0400, Paul Keyes wrote:
>
> I'm confused about one aspect of backing up and moving
> a database to a different server.
> I've used pg_dump to dump the database and moved he
> resulting file to the new server, where Postgresql is
> istalled and configured (as far
Hi everyone,
I am looking for the best way to compare the schemas of two databases with the
very similar structure.
One (certainly not the best options) is to do something like this:
pg_dump ... DB1 > PG_SCHEMA1
pg_dump ... DB2 > PG_SCHEMA2
diff PG_SCHEMA1 PG_SCHEMA2 > differences.txt
kwri
Hi All,
I'm confused about one aspect of backing up and moving
a database to a different server.
I've used pg_dump to dump the database and moved he
resulting file to the new server, where Postgresql is
istalled and configured (as far as I know).
But I know that before I run psql on the backup I h
Hi everybody,
I have tried to backup my postgres database with
pg_dump -Fc $db > ~/backups/$db.backup.c
and restore it with:
createdb -U postgres -D aestel_admin -T template0 restoreTMP
pg_restore -d restoreTMP -U postgres $db.backup.c
I do not get any error messages but none of my inde
Hello!
I'm trying to install postgresql on WindowsXP box using postgresql-8.0.msi.
The installation goes fine until running the service. I get a message
saying that postgre-8.0
failed to run as a service. I checked system log and came across an
error saying
that: PostgreSQL Database Server 8.0
To whom it may concern,
I currently have postgres 7.4.2 running on a dedicated server which has
1GB RAM and a Pentium 4 2600 Mhz processor.
After approximately 1 month I have to dump & restore the database
because vacuum time spirals out of control. To give you an idea of what
I experience, when
Thanks for your reply.
You want to edit postgresql.conf and set listen_addresses to *.
And you need to add a host or hostssl entry to pg_hba.conf allowing
a connection from your office machine.
Oh! Yes. I already had made this, and gave certain :o), but I can
connect only with trust mode (with
Howdy all. I'm doing some research on 'middleware' type connection
pooling, such as pgpool. I'm having some trouble finding other options
that are actively being maintained, whether it be by the open source
community or not. Can anyone point me to some other resources or ideas
for connection
Martin Fandel wrote:
> Which is the best solution? (Slony, DRDB, WAL or something else?)
Slony is a master/slave replication system that can improve overall read
performance. DRBD gives you a hot stand-by system. Both of these are
completely different goals, which can be implemented complement
Hi All,
I currently have postgres 7.4.2 running on a dedicated server which has
1GB RAM, a Pentium 4 2600 Mhz processor, uses ReiserFS filesystem and is
running Debian stable.
After approximately 1 month I have to dump & restore the database
because vacuum time spirals out of control. To give you
Magnus Hagander wrote:
> > Bruce Momjian writes:
> > > Martin Fandel wrote:
> > >> is DRDB (http://www.drbd.org/) a recommended
> > replication-solution for
> > >> PostgreSQL? I asked some PostgreSQL-People and DRDB-People on the
> > >> Linux-Tag in germany. But I'm not very assured about this
I "know" people can get PostgreSQL with the CSW
(www.blastwave.org) folk. However, most companies
stick to companion only software such as my own and
CSW in-house.
This package works along side the Solaris 10 03/05
(GA) companion CD.
You can download my package at
http://www.flipmotion.com/UNIX/
On Mon, Jun 27, 2005 at 12:14:34PM -0600, Werner Bohl wrote:
>
> Have a problem when restoring from an upgraded (from 8.01) 8.03
> database. On restore many tsearch2 functions aren't restored. Platform
> is Fedora Core 3 on x86.
> I remember seeing somewhere that a script must be run to upgrade sy
Hi all!
Have a problem when restoring from an upgraded (from 8.01) 8.03
database. On restore many tsearch2 functions aren't restored. Platform
is Fedora Core 3 on x86.
I remember seeing somewhere that a script must be run to upgrade system
catalogs. Where is this script?
TIA,
--
Werner Bohl <[
Hi,
I'm lost. Please give me a hint.
I'm currently fighting with myself of whether to use 8k blocks (pg's native)
or 64k Blocks (more data) as stripe set size.
...of course to get maximum performance. I want to setup a stripe set over 4
disks on a Solaris Sparc box with a stripe block size in que
On Mon, Jun 27, 2005 at 11:04:50AM +0500, Nasir Iqbal Danish wrote:
>
> I am using postgres 8.0.3, and wanted to use Point In Time Recovery enable.
> could any one tell me about how to indentify the current WAL file, also
> let me know if there is any fix patteren for WAL log file generations.
> d
"Magnus Hagander" <[EMAIL PROTECTED]> writes:
>> I have not probed further than the site's top page, but
>> unless DRBD offers some pretty strong guarantees about
>> physical write order on the master being duplicated on the
>> slave, it won't work reliably for Postgres.
> From what I've heard,
> Bruce Momjian writes:
> > Martin Fandel wrote:
> >> is DRDB (http://www.drbd.org/) a recommended
> replication-solution for
> >> PostgreSQL? I asked some PostgreSQL-People and DRDB-People on the
> >> Linux-Tag in germany. But I'm not very assured about this solution.
>
> > Uh, we really don'
Bruce Momjian writes:
> Martin Fandel wrote:
>> is DRDB (http://www.drbd.org/) a recommended replication-solution for
>> PostgreSQL? I asked some PostgreSQL-People and DRDB-People on the
>> Linux-Tag in germany. But I'm not very assured about this solution.
> Uh, we really don't _recommend_ repli
I think slony is the solution. thanks.
i will install it and will see the result.
Hellz_Waren
--- Jeff Frost <[EMAIL PROTECTED]> wrote:
> Sounds like slony is what you're looking for:
>
> http://slony.info/
>
> On Sat, 25 Jun 2005, hellz waren wrote:
>
> > Could you someone tell me if there'
Hi,
i went across a checkpoint problematic (90% load, near real time app). I've
read in pg-documentation what exists about CHECKPOINT and the configuration
parameters. But there're still many open questions as:
What actually happens if a checkpoint occours?
OK, all dirty pages of data files get w
Martin Fandel wrote:
> Hi all,
>
> is DRDB (http://www.drbd.org/) a recommended replication-solution for
> PostgreSQL? I asked some PostgreSQL-People and DRDB-People on the
> Linux-Tag in germany. But I'm not very assured about this solution.
Uh, we really don't _recommend_ replication solutions.
double quote the table name as
create table "123" (
...
)
The table can be accessed only with double quotes.
with regards,
S.Gnanavel
> -Original Message-
> From: [EMAIL PROTECTED]
> Sent: Mon, 27 Jun 2005 13:36:46 +0530
> To: pgsql-admin@postgresql.org
> Subject: [ADMIN] nemeric table
Hi all I want to create table in my database, But the table name must
begin from numric value.
Such As:
CREATE TABLE 123 (
name VARCHAR(20),
phone CHAR(20)
);
When i do this i got error message. Bottomline is that i want table
name starting with numeric value. Can
Hi all,
is DRDB (http://www.drbd.org/) a recommended replication-solution for
PostgreSQL? I asked some PostgreSQL-People and DRDB-People on the
Linux-Tag in germany. But I'm not very assured about this solution.
Which is the best solution? (Slony, DRDB, WAL or something else?)
Best regards,
Mar
25 matches
Mail list logo
