pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedTerminology Question
3+ messages / 3 participants
[nested] [flat]
* Terminology Question
@ 2007-08-20 14:36 Campbell, Lance <lance@uiuc.edu>
0 siblings, 2 replies; 3+ messages in thread
From: Campbell, Lance @ 2007-08-20 14:36 UTC (permalink / raw)
To: pgsql-performance
Terminology Question:
If I use the following statement:
I am backing up schema XYZ every 30 minutes.
Does this statement imply that I am only backing up the definition of
the data? Or does it mean that I am backing up the definition of the
data and the data within the schema object?
Thanks,
Lance Campbell
Project Manager/Software Architect
Web Services at Public Affairs
University of Illinois
217.333.0382
http://webservices.uiuc.edu
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Terminology Question
@ 2007-08-20 14:50 Scott Marlowe <scott.marlowe@gmail.com>
parent: Campbell, Lance <lance@uiuc.edu>
1 sibling, 0 replies; 3+ messages in thread
From: Scott Marlowe @ 2007-08-20 14:50 UTC (permalink / raw)
To: Campbell, Lance <lance@uiuc.edu>; +Cc: pgsql-performance
On 8/20/07, Campbell, Lance <lance@uiuc.edu> wrote:
>
> Terminology Question:
>
> If I use the following statement:
>
> I am backing up schema XYZ every 30 minutes.
>
> Does this statement imply that I am only backing up the definition of the
> data? Or does it mean that I am backing up the definition of the data and
> the data within the schema object?
In db parlance, schema means two different things really.
One is that layout of your data (how tables are related etc...)
The other is the namespace that a set of objects can live in. i.e.
There is a certain amount of overlap here as well.
dbname.schemaname.objectname.fieldname
In this instance, "backing up" a schema pretty much implies the
namespace version of schema.
OTOH, a phrase like "I think your schema has some design flaws pretty
obviously points to the first definition relating to the layout of
your data.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Terminology Question
@ 2007-08-20 17:55 Joshua D. Drake <jd@commandprompt.com>
parent: Campbell, Lance <lance@uiuc.edu>
1 sibling, 0 replies; 3+ messages in thread
From: Joshua D. Drake @ 2007-08-20 17:55 UTC (permalink / raw)
To: Campbell, Lance <lance@uiuc.edu>; +Cc: pgsql-performance
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Campbell, Lance wrote:
> Terminology Question:
>
> If I use the following statement:
>
>
>
> I am backing up schema XYZ every 30 minutes.
>
>
>
> Does this statement imply that I am only backing up the definition of
> the data? Or does it mean that I am backing up the definition of the
> data and the data within the schema object?
I read that as you are backing up the schema and all objects + data
within the schema XYZ every 30 minutes.
Joshua D. Drake
>
>
>
> Thanks,
>
>
>
> Lance Campbell
>
> Project Manager/Software Architect
>
> Web Services at Public Affairs
>
> University of Illinois
>
> 217.333.0382
>
> http://webservices.uiuc.edu
>
>
>
>
- --
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240
PostgreSQL solutions since 1997 http://www.commandprompt.com/
UNIQUE NOT NULL
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFGydWDATb/zqfZUUQRAjYBAJ0djuYjUDTSQXn2Crg5eEOgVZTDVACcC1M7
goKAhBqQWByziN5mVULUYo8=
=PZ/+
-----END PGP SIGNATURE-----
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2007-08-20 17:55 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-08-20 14:36 Terminology Question Campbell, Lance <lance@uiuc.edu>
2007-08-20 14:50 ` Scott Marlowe <scott.marlowe@gmail.com>
2007-08-20 17:55 ` Joshua D. Drake <jd@commandprompt.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox