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
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 pg_dump:
pg_dump -c -C -s schema > file.out
With this i have in file.out the schema, correct?
So, to restor
Hello everybody,
I'm trying backup restore of DB with LO.
I backuped using as superuser :
pg_dump -d -o -F t -b -u database --file=database.tar
Because the superuser is not the DB owner, I create the DB on another
server (same os ans same version of PGSQL which is 7.4.8 ) :
CREATE DATABASE
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)-
What is the most simple way to backup and restore only views?
Randall
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
Hi,
I've got a problem, I'm hoping someone can help me with.
It appears that my hosting provider has "restored" my database as
part of a maintenance project. The problem is that the backup didn't
include my large objects.
I've got an older backup that has all the large objects, but I don'
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
What is the most recommended way to backup a
PostgreSQL database?
And to restore it?
I would like to get ALL the data and properties
possible, because if I have a problem, and I lost my
current database, I can just restore it, and will be
all exactly like was before.
What is the best way? pg_du
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
(B
(B
(BHi
(BI'm in charge of a linux DB server running postgres
(B7.3.2.
(BThe OS disk recently died taking the postgres
(Binstallation
(Bwith it but the data directory of postgres was on a
(Bseperate SCSI
(Bdisk and is still OK.
(B
(BI've put in a new OS disk, installed linux on
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
Any Help
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 "successful"
"psq
I'm doing some migration script from mysql database to an existing
postgresql database. Everytime I want to test it, I want to get the postgres
"destination" database to the same situation it was before the last script
was run.
I am doing a backup with pgdump and restoring by droping the databas
Dear all,
I am trying to restore a backup of database created by
pg_dump. But I got the following error, no matter I
use command a or b.
Why pg_restore try to create stuff while data only
option is given?
--- log ---
command (a)
su -l pgsql -c "pg_restore -d db01
/export/data/subsys/backend/ar
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.
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. How do I destroy a database
so that it is truly gone!?!?!? I need a totally cl
What is the best way to backup and restore large objects in the
database? I don't think dump/dumpall can handle large objects or
certain column types like serial. I hope there is a good way to do it
such that if I upgrade to a new version of postgresql, I will be able to
restore everything. I u
19 matches
Mail list logo
