Postgres Pro
Downloads
Home   >   mailing lists

Thread: Terminology Question

Terminology Question

From
"Campbell, Lance"
Date:

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

 

Re: Terminology Question

From
"Scott Marlowe"
Date:
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.

Re: Terminology Question

From
"Joshua D. Drake"
Date:
-----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-----