473,856 Members | 1,721 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Restore after server crash

2 New Member
Hi there,
to make it short, my server crashed some days ago, and I could only save the data folder of one tablespace, witch was located on another HDD. Now I am trying to restore my database, but it does not work!
What I did:
Installed postgresql-8.2
created an new tablespace named as it was before
created a new database named as it was before
stopped postgres
replaced the whole folder
started postgres

but the created DB is still emtpy!

I am new to postgres so appologize my dump question, if it is one :)

regards,
benny
Sep 13 '07 #1
1 3150
bennyg96
2 New Member
Hi there,
to make it short, my server crashed some days ago, and I could only save the data folder of one tablespace, witch was located on another HDD. Now I am trying to restore my database, but it does not work!
What I did:
Installed postgresql-8.2
created an new tablespace named as it was before
created a new database named as it was before
stopped postgres
replaced the whole folder
started postgres

but the created DB is still emtpy!

I am new to postgres so appologize my dump question, if it is one :)

regards,
benny

*push: no one can help!?
Sep 19 '07 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

2
2174
by: For example John Smith | last post by:
Is there any reason why SQL Server (EM) would go through all the motions of a restore and not actually do anything at all? To get into this situation I backup from a client's server and download that backup to my server where I restore it, as I hate having to type in the physical path names each time what I did was backup my old copy to a file, then replace that file with the one I downloaded and then do a Restore operation and use the...
13
23466
by: | last post by:
Hi I am trying to copy a 20 GB database from server 1 to 2. I took a full backup, copied to server2 and restored ( ready for use) using EM. After the message restore completed, I see the database's status as LOADING. We are on Sql Server 2000 (8.00.818) on Windows 2000 Adv Servers. I ran dbcc on the source DB and it returned no errors. I tried the command 'restore db with recovery ' which didnot help. I get an message saying that
3
6048
by: Jon Jacobs | last post by:
I attempt to back up a database on one server and restore it on my local machine. This is what the query text looks like: restore database model from Disk='c:\JQJ\mydump\model.bak' with replace I get this error:
3
11536
by: cefrancke | last post by:
The only reason I ask is that no one has made this subject clear or given a definitive answer. What I would like to do is, after turning off all the menus/tbars/etc using the startup options. Upon restarting Access, when an admin is detected (I use a GetSystemUser() function) I want to restore everything so that Access behaves like normal, ie. all menus/tbars/etc show up (only where they are supposed to show up).
0
3157
by: Takpol | last post by:
Hello, I have several archived filegroups that have data in them partitioned based on the date. These filegroups have been removed from database after archival. For example two months ago. Meantime my production database is populating everyday. Now I would like to restore one of my old archived filegroups. In order to do that I would like to backup and restore the current Primary filegroup to another server, and also restore the...
5
3246
by: HSP | last post by:
hi. i need to restore an old database. The db was backed up using a DLT drive, using 2 volumes. The content for the tapes was copied to file onto Solaris machine using rsh and dd (for backup purposes). Now, the drive is defective and can't read the tapes anymore. Server is AIX 4.3.2 and database is IBM DB2 Server (DB2 for AIX Version 2.1.2)
13
6006
by: danceli | last post by:
I have two servers, using SQL server 2000. I was asked for implementing hourly Backup 3 databases in one server and restore those databases to another server. Could anyone give me the detailed steps to do that? Thanks a lot in advance!
5
7119
by: smoi | last post by:
Hi all, My manager ask me to do backup for 3 database and restore them in a new server. I did the backup for the 3 database into BAK file. Then in the new server, when I did the restore in SQL Server Enterprise Manager by using their restore function and selecting device(s) for the BAK file, I encounter the different messages such as the following: 1. Microsoft SQL-DMO (ODBC SQLState: 4200) The media family on device 'C:\Backup.BAK' is...
1
5082
by: ravish79 | last post by:
Can anyone tell me about database backup and restore. There are lot many dumps available but i want to use tar/gzip backup. also provide me information about restoring it in case of db crash. Method i use should be easy and fast. From C# as front end in linux server I should be able to do this. I will be more happy if somebody helps me on this scenario.
0
9903
marktang
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...
0
9755
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10692
jinu1996
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...
1
10770
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,...
0
10376
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
5954
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4567
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
4168
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3194
bsmnconsultancy
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.