Postgres: Restoring A Filesystem Backup

Feb 19, 2007

i had to do a file system back up because of the size of my database.

i shutdown postmaster and tar'd the files.

i recently reloaded my OS and now i'm attempting to restore the backups. i first shut down postmaster, restored the backups to the data folder and restarted postmaster.

i then su'd from root to postgres user:

Code:
[postgres@austin1 pgsql]$ psql service_2_3
psql: FATAL: database "service_2_3" does not exist
DETAIL: The database subdirectory "base/16385" is missing.

the backups had a database named service_2_3 but upon restoring the backups, it doesn't seem to be available.

my data directory is /var/pgsql/data.

Code:
[postgres@austin1 pgsql]$ ls -lahR /var/pgsql/ | grep 16385
but that yielded nothing.

have i done something wrong while backing up? i don't think i have since i followed the postgres manual when backing up. but the administrators have not been very thorough with how they've set the system up for me.

how i can resolve this issue if you have the time.

View 6 Replies


ADVERTISEMENT

Restoring 1.5GB SQL Dump (Postgres)

Jan 23, 2007

This seemed like the most appropriate place so I decided to post here.

SYSTEM:
Fedora Core 4, 3GHz, 2GB RAM
Postgres 8, Apache 2, PHP 4

The issue is that I have with me a 1.5GB SQL dump from Postgres 8 which I extracted using pg_dump.

Restoring it seems to be an issue on this PC. I've tried modifying memory directives in postgresql.conf as well as the kernels SHMAX value but no go.

I tried a bunch of other things such as gzipping the file so that it was only 100mb and doing:

Code:
gunzip -c dump.sql.gz | psql my_db
But I recieved many errors saying "invalid command N" and I also got a syntax error notice and the process terminated.

I tried to at least try and enter some data manually but vim is incredibly slow since this is a 1.5GB file.

Is there a way I could perhaps split up my db dump and then import them into the db one by one?

View 2 Replies View Related

E2label (Restoring Backup From Old Primary)

Apr 19, 2008

I have a smart error of possible hard drive failure on a hard drive of a cPanel server. Before I ask for replacement of new drive,

I'm going to get a new hard drive as New Primary
and make the Old Primary as Secondary Drive (To Restore)

I have the complete manual to restore. However the last time I tried to do that same thing, the system OS crash because it cannot tell which one is primary, and which is secondary (Both is SATA)

My partition is
/boot 100mb
swap 2gb
/tmp 500mb
/ rest of disk
no LVM, installed on MBR

I remember the last time I read something about e2label to rename my hdd label which cause the OS crash when new+old primary was booted together.

View 4 Replies View Related

Restoring SQL Database Backup To Invision Power Board

Nov 24, 2007

I moved my site to a new host and am running IPB 1.3 forums,

I have a 62meg sql backup to restore.

I have tried using BIGDUMP.php as max upload is over 52megs.
No Joy!

I also tried zipping the file, got it down to 9megs,

It wont complete the upload in PhpMyAdmin?

I have not had to restore a back up before, and am really struggling.

View 4 Replies View Related

Plesk 12.x / Linux :: Restoring Backup After Server Reinstall

Mar 18, 2015

Is it enough to restore the full server backup via the web interface of Plesk to get everything running fine after a reinstall, or is there something else I should do ? I have all kind of backups (server, domains, customers). My server is running Plesk 12 on Ubuntu 12, and I think I will have Ubuntu 14 on the new installation. My backups are on a server on the same local network than my server.

View 3 Replies View Related

Plesk 12.x / Windows :: Restoring Backup From DropBox Failed

Dec 17, 2014

I tried to import / restore a backup from dropbox but it was unsuccessful,

Restoration of the backup","status":Failed to Execute: "C:Program Files (x86)ParallelsPleskinpleskrestore.exe" --restore "C:Program Files (x86)ParallelsPleskvarmodulesdropbox-backupdomain.tld.tar" -level domains -filter list:domain.tld

View 3 Replies View Related

Plesk 12.x / Linux :: Backup Of Whole Server - Restoring Domain And Configuration?

Feb 21, 2015

I update the backup of whole server (the file is .xml.tar)

Now how can I restore all my domains, server.configuration and so on?

View 13 Replies View Related

Postgres Install

Feb 19, 2008

I have a server running Cpanel and I have added postgres through /scripts/installpostgres, also I have set it over WHM and can access phppgadmin but I got this error when connecting throug a script

Fatal error: Call to undefined function: pg_connect() in /home/rer1223/public_html/process/Connection.php on line 4

I checked and postgres is not listed in phpinfo output.

View 5 Replies View Related

Running Postgres

Feb 20, 2008

I have installed postgres over my cpanel account but I am unable to find php_pgsql.so file

I am running Centos 4 Apache 1.3 PHP 4.3 Postgres 7.3

View 4 Replies View Related

Cannot Add Postgres Database

Jul 9, 2007

PostgreSQL (Cannot add new user or database). It will return "User/DB added successfully" but no new user or database is added.

root@server [~]# rpm -qa | grep postgre
postgresql-devel-8.1.4-3PGDG
postgresql-contrib-8.1.4-3PGDG
postgresql-8.1.4-3PGDG
postgresql-server-8.1.4-3PGDG
postgresql-libs-8.1.4-3PGDG
postgresql-python-8.1.4-3PGDG

I've already compiled apache after postgres was upgraded months ago.

I'm using cpanel 10x

View 1 Replies View Related

Cron As Postgres User Not Working

Jun 14, 2007

I was hoping someone could shed some light on a cron related issue I'm having.

I've been using linux for a while...but never really used crons.

My cron is supposed to dump a postgres db in tar.gz format every minute (for testing purposes) but it doesn't.

I opened my cron in vim via:

Code:
postgres@myhost:~$ crontab -e
And here's the cron:

Code:
* * * * * /usr/bin/pg_dump -D warranty_1_6_test | gzip -c > /var/www/test/postgres/backup$(date +"%Y%m%d_%H%M").tar.gz

Also:

Code:
postgres@myhost:~$ ls -lah /var/www/test/postgres/
total 8.0K
drwxrwxrwx 2 postgres postgres 4.0K 2007-06-14 12:01 .
drwxr-xr-x 3 user user 4.0K 2007-06-14 11:47 ..

Running the backup command via CLI works fine.

View 5 Replies View Related

IDENT Authentication Failed For Postgres. Pg_hba.conf

Feb 15, 2007

I just reloaded the OS on our production server and I'm having issues configuring postgres.

the user postgres exists in the system (i.e. 'su postgres' switches me to that user)
i attempted to connect to my database 'service_2_3' via CLI:

Code:
$ su postgres
$ psql service_2_3
and i recieved the following error:

Code:
psql: FATAL: IDENT authentication failed for user "postgres@service_2_3"
the database is installed on the machine on which i was attempting to connect to it with.

therefore, i edited my pg_hba.conf so that it looks like this:

Code:

# TYPE DATABASE USER CIDR-ADDRESS METHOD

# "local" is for Unix domain socket connections only
local all all ident sameuser
# IPv4 local connections:
host all all 127.0.0.1/32 ident sameuser
# IPv6 local connections:
host all all ::1/128 ident sameuser
host all all 0.0.0.0 0.0.0.0 password

and reloaded with (as user postgres):

Code:
bash-3.00$ pg_ctl reload -D /var/lib/pgsql/data -l /var/lib/pgsql/data/temp.log

but i still get the same error. am i editing the wrong file, perhaps?

how would i know which is the correct pg_hba.conf file?

locate pg_hba.conf seems to give me a few results.

View 3 Replies View Related

Mount Tmp As Filesystem

Jun 6, 2009

I currently have a VPS. I have installed cPanel/WHM + CSF Firewall.

Everything is fine and all the ports are closed except for the ones I need.

I currently have some issues I need to fix, but google isn't helping

Quote:

Check /tmp is mounted as a filesystemWARNING/tmp should be mounted as a separate filesystem with the noexec,nosuid options set

I tried googling this and there was a cPanel script but I do not have permission to run it. So does anyone mind explaining it to me one step at a time?

Quote:

You should consider adding ini_set to the disable_functions in the PHP configuration as this setting allows PHP scripts to override global security and performance settings for PHP scripts. Adding ini_set can break PHP scripts and commenting out any use of ini_set in such scripts is advised

I have disabled this in php.ini but I do not know why it still says that I have to fix this

View 4 Replies View Related

Read Only Filesystem

Feb 26, 2008

I have a server with pacificrack. When I see my website it says "Read-Only File system" and my SSH dies with read-only file system errors.

It happens once per month, and the bad thing is I'm sleeping when it happens so I don't know my server is in this state.

Even though support fixes the problem within 15minutes of my support ticket, my server is down for hours because I don't know its down to then raise a ticket. I asked support why it happens and they never tell me... just tell me to read the logs but I'm not technical enough to understand linux logs etc.

Server is centos.

View 14 Replies View Related

Filesystem Became Read-only

Jun 4, 2007

Somehow the filesystem on my server turned read-only. The databases would not connect. When I rebooted the box it would not come up.

Support had to run FSCK. Even after, the databases had to be repaired using the CPanel tool. Things seem to be ok now, however:

1. What could have caused this to happen? Software or hardware failure?

2. I get these notifications, should I be worried?

WARNING: Kernel Errors Present
EXT3-fs error (device sda2): e...: 1 Time(s)

View 4 Replies View Related

Ext3 On A Very Large Filesystem

May 23, 2008

We're considering deploying a large server that will have 8x 500GB drives in a RAID-10 config. I intend to use a 3ware 9650SE w/ BBU along with A/B power to each of the PSU's.

My question is... since this will return into a 2TB array/partition, in event of a crash (kernel panic, etc -- I expect a power outage will be very, very rare if at all) what do you guys think the fsck time would be? In my experience a RAID BBU significantly drops it, sometimes to the point of no manual fsck required, but in event of a manual fsck shouldn't the BBU be able to provide more consistent data (less errors) and therefore a much shorter fsck? Maybe just recovering the journal?

View 14 Replies View Related

Check /var/tmp Is Mounted As A Filesystem

May 30, 2007

I have WHM/cPanel server.

I am installed ConfigServer (Firewall)

On configserver it says " /var/tmp should either be symlinked to /tmp or mounted as a filesystem" how can i do this?

View 11 Replies View Related

ISCSI Windows Clustered Filesystem

Oct 5, 2008

I'm currently connecting one of my servers to an iSCSI SAN but would like to hook up another server to that target as well. However, this doesn't work with NTFS filesystem and I couldn't really find any windows solutions for that. Does anyone have experience with this?

View 5 Replies View Related

Quotacheck: Can't Find Filesystem Cpanel

Mar 16, 2007

My /etc/fstab:

Code:
# cat /etc/fstab
# This file is edited by fstab-sync - see 'man fstab-sync' for details
LABEL=/1 / ext3 defaults,usrquota 1 1
LABEL=/boot /boot ext3 defaults 1 2
none /dev/pts devpts gid=5,mode=620 0 0
none /dev/shm tmpfs rw,noexec,nosuid,nodev 0 0
none /proc proc defaults 0 0
none /sys sysfs defaults 0 0
LABEL=SWAP-sda2 swap swap defaults 0 0
/dev/sdb1 /backups ext3 defaults 1 2

Code:
# /scripts/fixquotas

Installing Default Quota Databases...../aquota.user..../quota.user..../boot/aquota.user..../boot/quota.user..../backups/aquota.user..../backups/quota.user.....Done
Quotas are now on
Updating Quota Files......
quotacheck: Can't find filesystem to check or filesystem not mounted with quota option.
quotacheck: Can't find filesystem to check or filesystem not mounted with quota option.

....Done

AND

root@srv01 [/www/logs]# /scripts/initquotas
Quotas are now on
Updating Quota Files......
quotacheck: Can't find filesystem to check or filesystem not mounted with quota option.
quotacheck: Can't find filesystem to check or filesystem not mounted with quota option.

....Done

View 6 Replies View Related

Optimal HDD And Filesystem Settings For Web Hosting

Dec 29, 2007

I am in the process of configuring my volumedrive dedicated server and would like some input on ideal settings for my filesystem.

I'd appreciate suggestions and explanations of what they options do.

Here is my system info:
Linux volumedrive.com 2.6.18-53.el5 #1 SMP Mon Nov 12 02:14:55 EST 2007 x86_64 x86_64 x86_64 GNU/Linux
CentOS release 5 (Final)

AMD Sempron64 3000+
1GB RAM

HDD:
Location: SCSI device B
Cylinders: 60801
Size: 465.76 GB
Model: ATA ST3500320AS

Seagate Barracuda 7200.11 ST3500320AS 500GB 7200 RPM
32MB Cache SATA 3.0Gb/s Hard Drive

Parameters I can change:
EXT 3 File System Configuration Options:
Block size
Fragment size
Bytes per inode
Reserved blocks
Journal file size

Edit IDE Parameters
Transfer mode: Default mode / Disable IORDY / PIO mode 1,2,3,4 / Multimode DMA 0,1,2 / Ultra DMA 0,1,2
Using DMA: On/Off
Sector count: 256
Read-lookahead: On/Off
Write caching: On/Off
Interrupt unmask: On/Off
Keep settings over reset: On/Off
Keep features over reset: On/Off
Read only: On/Off
Reprogram best PIO: On/Off
Standby timeout: 0
32-bit I/O support: Disable / Enable / Enable with special sync sequence
Sector count for multiple sector I/O: Disable 2 4 8 16 32

View 0 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved