|
by: Lucas Lain |
last post by:
Hi everybody ... i need to restore only one database from a pg_dumpall backup
file... how can i do it?
Thanks a lot !
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
|
by: Mike Nolan |
last post by:
I have a 600K row table on my production system (running 7.3.3)
that I dump and load on my development system (7.4.1) every night using
cron jobs.
I would like to be able to restore the table under a different table name
without first having to play games with the development copy of the table.
If I edit the dump file with 'sed' to change the table name, I get
'invalid command \N' errors trying to reload it.
|
by: mike |
last post by:
I have just upgraded froom Fedora test1 to test2 which has upgraded
postgres version from 7.4.2 to 7.4.5 (frrom rpm -q)
I have used pg_dumpall to dump my database, the restore appeared to go
OK, except there is no data in two of my tables (only these two)
output from \d \d tb_invoice_header
Table
"public.tb_invoice_header"
Column | Type
|
by: Együd Csaba |
last post by:
Hi All,
I'd like to dump out my database using plain text format. Everything is ok,
but the bytea filds.
Restoring the dump file (using <<psql -f LO_TRY_INSERT_BYTEA.sql tmp7>>) it
sends an error message like
psql:LO_TRY_INSERT_BYTEA.sql:14: ERROR: Bad input string for type bytea
Trying dumping with copy commands it sends this error:
psql:LO_TRY_COPY_BYTEA.sql:13: lost synchronization with server, resetting
|
by: Michal Taborsky |
last post by:
Hi there.
I had a weak moment and accidentally ran a dump restore script on
template1 instead of proper database. So my template1 is now polluted
with many tables, sequences and the like.
Is there a way to restore a pristine template1? I haven't done any
modifications to it, so I'd be good with the one distributed with
default installation. Is it safe to DROP DATABASE template1 and recreate
it with dump from different cluster?...
|
|
by: Clodoaldo Pinto Neto |
last post by:
Hi all,
I'm restoring a database from 7.3.4 FC1 to 7.4.2 FC2:
$ pg_restore -d KakaoStats KakaoStats.dump
pg_restore:
could not execute query: ERROR: could not access file
"$libdir/plpython": No such file or directory
The dump was generated with the command:
|
by: Mark Gibson |
last post by:
Hello,
I've just encountered a problem that I don't know how to deal with.
After having a play with SlonyI, I dropped the entire slony cluster
schema, and then tried to drop a schema which held some slave tables
for the slony cluster.
I kept getting the following error:
ERROR: cache lookup failed for relation 4667548
|
by: Együd Csaba |
last post by:
Hi,
the restoration of a dump stops at the line above. The dump was created with
pgsql 7.3.2 and I need to pump it into a 7.4.3 one. Should anybody tell me
what the problem can be and how I can solve it.
(There are double apostophes many times in the string - is it normal???
Besides of the field separator of course...)
Many thanks,
Csaba Együd
|
by: chenert |
last post by:
Hi all,
im beginner to restoring dump files and postgresql as well so hope u could bear with me.! :D
i have these dump files and i've been working on restoring everything in it.
i've tried this command :
psql -U postgres dbname < data.dump :
the tables were restored wihout any data inside it.
does anyone know how I could fix this? :D
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
|