pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedWhere's the Database?
4+ messages / 4 participants
[nested] [flat]
* Where's the Database?
@ 2001-04-17 01:47 Mike Marois <Mike@HireLiveMusicians.com>
0 siblings, 0 replies; 4+ messages in thread
From: Mike Marois @ 2001-04-17 01:47 UTC (permalink / raw)
To: pgsql-docs
Hey List;
I've been really getting into PostgreSQL attempting to rewrite my current
website ( www.HireLiveMusicians.com ) with a DB backend. The site is
working on flat text files currently. My question is for archiving/backing
up and just general knowledge, where are my databases being stored by
default. I've been creating the database logged on a specific user not
root. I'm just curious, I know that I'm supposed to write scripts to create
the tables, triggers, indexes, etc and then import my exported data back
into the tables if something runs amiss.
TIA
Mike
www.HireLiveMusicians.com
www.MaroisApps.com
www.TheDukesofDixieland.com
^ permalink raw reply [nested|flat] 4+ messages in thread
* Where's the Database?
@ 2001-04-17 01:51 Big Bad Data Daddy <B2D2@MaroisApps.com>
2001-04-17 06:32 ` Re: Where's the Database? Oliver Elphick <olly@lfix.co.uk>
2001-04-17 16:32 ` Re: Where's the Database? Roberto Mello <rmello@cc.usu.edu>
0 siblings, 2 replies; 4+ messages in thread
From: Big Bad Data Daddy @ 2001-04-17 01:51 UTC (permalink / raw)
To: pgsql-docs
Hey List;
I've been really getting into PostgreSQL attempting to rewrite my current
website ( www.HireLiveMusicians.com ) with a DB backend. The site is
working on flat text files currently. My question is for archiving/backing
up and just general knowledge, where are my databases being stored by
default. I've been creating the database logged on a specific user not
root. I'm just curious, I know that I'm supposed to write scripts to create
the tables, triggers, indexes, etc and then import my exported data back
into the tables if something runs amiss.
TIA
Mike
www.HireLiveMusicians.com
www.MaroisApps.com
www.TheDukesofDixieland.com
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Where's the Database?
2001-04-17 01:51 Where's the Database? Big Bad Data Daddy <B2D2@MaroisApps.com>
@ 2001-04-17 06:32 ` Oliver Elphick <olly@lfix.co.uk>
1 sibling, 0 replies; 4+ messages in thread
From: Oliver Elphick @ 2001-04-17 06:32 UTC (permalink / raw)
To: B2D2@MaroisApps.com; +Cc: pgsql-docs
"Big Bad Data Daddy" wrote:
>Hey List;
>
>I've been really getting into PostgreSQL attempting to rewrite my current
>website ( www.HireLiveMusicians.com ) with a DB backend. The site is
>working on flat text files currently. My question is for archiving/backing
>up and just general knowledge, where are my databases being stored by
>default. I've been creating the database logged on a specific user not
>root. I'm just curious, I know that I'm supposed to write scripts to create
>the tables, triggers, indexes, etc and then import my exported data back
>into the tables if something runs amiss.
Your databases are stored where you told initdb to put them.
When you create a new database it goes in the same directory as all the others;
ownership is not relevant to that, since all the files are owned by the
postgresql administrator login.
--
Oliver Elphick Oliver.Elphick@lfix.co.uk
Isle of Wight http://www.lfix.co.uk/oliver
PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47 6B 7E 39 CC 56 E4 C1 47
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"But as many as received him, to them gave he power to
become the sons of God, even to them that believe on
his name." John 1:12
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Where's the Database?
2001-04-17 01:51 Where's the Database? Big Bad Data Daddy <B2D2@MaroisApps.com>
@ 2001-04-17 16:32 ` Roberto Mello <rmello@cc.usu.edu>
1 sibling, 0 replies; 4+ messages in thread
From: Roberto Mello @ 2001-04-17 16:32 UTC (permalink / raw)
To: Big Bad Data Daddy <B2D2@MaroisApps.com>; +Cc: pgsql-docs
On Mon, Apr 16, 2001 at 08:51:28PM -0500, Big Bad Data Daddy wrote:
> Hey List;
>
> I've been really getting into PostgreSQL attempting to rewrite my current
> website ( www.HireLiveMusicians.com ) with a DB backend. The site is
> working on flat text files currently. My question is for archiving/backing
> up and just general knowledge, where are my databases being stored by
> default. I've been creating the database logged on a specific user not
> root. I'm just curious, I know that I'm supposed to write scripts to create
> the tables, triggers, indexes, etc and then import my exported data back
> into the tables if something runs amiss.
Oliver already answered the first question. If you are using RPMs or
DEBs to install Postgres, your databases should be in
/var/lib/postgresql/data
It's a very good idea to read tho scetion on Backups on the
Administrator's Guide.
-Roberto
--
+----| http://fslc.usu.edu USU Free Software & GNU/Linux Club |------+
Roberto Mello - Computer Science, USU - http://www.brasileiro.net
http://www.sdl.usu.edu - Space Dynamics Lab, Developer
Beam me aboard, Scotty! How about A 2x4, sir??
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2001-04-17 16:32 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-04-17 01:47 Where's the Database? Mike Marois <Mike@HireLiveMusicians.com>
2001-04-17 01:51 Where's the Database? Big Bad Data Daddy <B2D2@MaroisApps.com>
2001-04-17 06:32 ` Oliver Elphick <olly@lfix.co.uk>
2001-04-17 16:32 ` Roberto Mello <rmello@cc.usu.edu>
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