Hi Scott,
I m real new in this so be patient :)
I check in postgres and:
radius-# \l
List of databases
Name| Owner | Encoding
---+--+--
postgres | postgres | UTF8
radius| postgres | UTF8
root | postgres | UTF8
template0 | postgres | UTF8
Lots there, let's break it down individually:
On Mon, Mar 22, 2010 at 6:38 AM, blast wrote:
>
> Hi all,
>
> I need to backup and restore a DB.
> In this particular case the data in the database is not important (strange
> hum...) but only the schema to put new data...
>
> I m thinking use the p
Your best bet would be to query the system tables. Something like
SELECT definition FROM pg_views;
On Thu, Nov 03, 2005 at 12:43:47PM -0600, Randall Smith wrote:
> What is the most simple way to backup and restore only views?
>
> Randall
>
>
> ---(end of broadcast)-
Dear Eduardo ,
What is the most recommended way to backup a
PostgreSQL database?
pg_dump --disable-triggers -U -a -d -b -D -Fc -Z 9 -f
+
A file system backup could be done but for this you will have to
shutdown PostgreSQL server
before filesystem backup is done
And to restore it?
pg_re
You ought to be able to just start up Postgres pointing to the existing
data. So assuming the
data directory is /db, just doing 'postmaster -D /db' should work.
Provided, of course, you installed the exact version that was there
before, with the same user/uid
as before.
On Nov 11, 2003, at 9:51
creid writes:
> I recently upgraded to 7.3.4 from 7.3.2. Prior to the upgrade I used
> "pg_dump -a > olddatafile" for just data and "pg_dump -s > oldschemafile"
> for schema using the pg_dump utility from 7.3.2. After a "successful"
> install of 7.3.4, I created the database then went on to "suc
This happens on Slackware as well.
"Ross J. Reedstrom" wrote:
> On Fri, Sep 08, 2000 at 04:13:20PM -0700, Lindell Alderman wrote:
> > I am trying to backup and restore a database, but when run the following:
> >
> > dropdb test
> > createdb test
> >
> > I find that the newly created database "te
On Fri, Sep 08, 2000 at 04:13:20PM -0700, Lindell Alderman wrote:
> I am trying to backup and restore a database, but when run the following:
>
> dropdb test
> createdb test
>
> I find that the newly created database "test" is not empty but still has
> all of the old relations and tables in it.
