Server :: Restoring A Postgres Database?

Jun 9, 2010

We have a disaster recovery solution for our database where a dump file is generated daily at 1:00 AM. We have tested importing the file, along with running another sql file that generates the appropriate database user accounts, into a database on a third-party server.

One question that came up was the following: Suppose the database crashes in the middle of the day, prior to that there were transactions that were entered into the database between the time the dump file was generated, and the crash occurred. We can restore the dump file to either the main or backup server. How can the transactions that were made between the time of the dump file and the crash be restored as well?

View 2 Replies


ADVERTISEMENT

Server :: Upgrading Bacula Database For Postgres?

Mar 24, 2011

While backing up/restoring bacula clients. We were getting an error regarding database tables' version. The error message is given below.. "Found 10 needs 12".

After Googling, what we found is, we have to update the postgres database for bacula. So now we are in process to update the database via the update_bacula-tables script. We are not sure, if it will solve the problem or not. We have just upgraded bacula 2.4.4 to 5.0.1. Postgres version is upgraded from 8.3 to 8.4. It is Debian 6.0 squeeze.

View 2 Replies View Related

General :: Centos Search For Postgres Database?

Jan 31, 2011

Ok so I need to Search for a postgres database File on a CentOs System. Is their a command i can run in the terminal to search for postgres files?

View 2 Replies View Related

OpenSUSE :: Test Out Restoring The Database?

Sep 19, 2010

I currently backup my database using MySQL Administrator. I wanted to test out restoring the database, so on my test server I deleted the database and restored the .sql file to a new schema with the same name as the old. one. It appears to complete the process just fine. But I noticed that the number of rows for the restored database is slightly less than what was backed up.

Is this normal or should the numbers be exactly the same? It's only a difference of about 28 rows. I seem to be able to view the data just fine in the query tool.

View 4 Replies View Related

General :: Restoring The Dumped Database In Mysql?

Oct 14, 2010

in my fedora machine i gave

mysqldump <database-name> > bakup.sql
in my solaris machine i gave
mysql <newly created dbname> < bakup.sql
it shows the below error

ERROR 1064 at line 25: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1' at line 7

mysql version in my fedora machine is
mysql Ver 14.14 Distrib 5.1.47
mysql version in my solaris machine is
mysql Ver 12.22 Distrib 4.0.24

View 4 Replies View Related

Security :: Restart Postgres In Server - Selinux Is Not Letting It Log Anything

Jan 28, 2010

Whenever i restart postgres in my server, Selinux is not letting it log anything. In /var/log/messages, it says.

Quote: Jan 28 14:15:43 dataserver kernel: audit(1264709743.263:38): avc: denied { append } for pid=5986 comm="postmaster" name="pgsql.log" dev=sda8 ino=3932166 scontext=root:system_r: postgresql_t tcontext=root: object_r:var_log_t tclass=file

Jan 28 14:15:43 dataserver kernel: audit(1264709743.263:39): avc: denied { append } for pid=5986 comm="postmaster" name="pgsql.log" dev=sda8 ino=3932166 scontext=root:system_r: postgresql_t tcontext=root: object_r:var_log_t tclass=file

I cannot disable SeLinux in this server.

View 1 Replies View Related

Server :: System Error - Authentication Failed For User Postgres

Mar 29, 2011

I made a system in CentOS5.5. I used Tomcat6 and PostgreSQL. But I couldn't enter my system. There are some error. And I don't understand what kind of error this.
JDBCExceptionReporter.logExceptions(100) | SQL Error: 0, SQLState: null
JDBCExceptionReporter.logExceptions(101) | Cannot create PoolableConnectionFactory (FATAL: Ident authentication failed for user "postgres")
"postgres" is username.
Is anybody knows anything about this error message.

View 4 Replies View Related

CentOS 5 Server :: Login As Postgres User And Enter Commands?

Sep 10, 2010

I've had a server setup working perfectly for the last 2 years. Today we installed a newer version of postgresql and recompiled apache/php.

Postgresql will not start now.

"service postgresql start" = /var/lib/pgsql/data is missing. Use "service postgresql initdb" to initialize the cluster first. To initdb we need to be as user postgres.

"su - postgres" = "no file or directory"

In /etc/passwd = postgres:x:26:26:PostgreSQL Server:/var/lib/pgsql:/bin/bash

how i can login as postgres user and enter these commands?

View 2 Replies View Related

Server :: Database Stopped Showing Up - Files Still There - Restore The Database From The Files?

Jul 8, 2011

I recently moved into a new place and when I hooked up my webserver, I wasn't able to bring up my page, even from localhost. With some digging, it seems that I can't access the database that housed my posts (wordpress installation). I looked for the datadir in MySQL and that directory shows the wordpress directory that should be holding the database and all the files are still there. 1) why the database no longer shows up 2) how to restore the database from the files?

View 2 Replies View Related

Server :: Restoring A Guest OS From LVM?

Oct 1, 2010

I took a backup of a guest OS running in an LVM.When I took the backup I created a snpashot of LVM and mounted thatsnapshot in some location.Used rsnc to copy its contents to a USB drive.Can I boot "somehow"from this copy of Guest OS which is now in USB drive?I am using KVM on 64 bit 10.04.

View 1 Replies View Related

General :: Restoring RedHat Enterprise Server X64 5.4?

Jul 11, 2011

at work place I have an HP ProLiant DL580 with RedHat Enterprise Server 5.4 x64. Today I cloned this machine using clonezilla. What I would like to do is restore the image to VMWare machine for personal purpose (I cannot perform tests on production machine). But after restoring on VMWare I got "Kernel Panic". That's normal due to different hardware.

Now, is there a way to remove the Kernel Panic and correctly boot the machine? I ask our tech department for the RedHat CD1 to enter the "linux rescue" enviromnent, then try to re-read the hardware list with

# chroot /mnt/sysimage
# kudzu

View 3 Replies View Related

Ubuntu Installation :: Restoring Sources.list In 10.04 Server?

May 29, 2010

Hi. I killed my /etc/apt/sources.list So i desided that dpkg-reconfigure will helps me to restore it, but I was wrong.

Code:

# dpkg-reconfigure apt

Why this command didnt restore sources.list file? Can someone give me standart sources.list for Ubunti 10.04 Server?

View 3 Replies View Related

Ubuntu Servers :: Remotely Restoring A Server Using An Image And The Dd Command?

Apr 18, 2010

I'm getting ready to deploy a Ubuntu server in a remote location. I am deathly afraid of something going horribly wrong though, so what I'd like to do is be able to somehow image the system when it's working, and be able to restore that remotely via SSH if things go to hell. My first thoughts were that I could partition the hard drive, and install two separate instances of Ubuntu. One would be the server in it's working state, and the other one would be a separate instance of Ubuntu that I could boot into to restore an image (if that's possible).

1. If I had two separate instances of Ubuntu on two separate partitions, and I was currently booted into one of them, would it be possible to tell the Ubuntu server to reboot and boot into the other instance of Ubuntu on the other partition over SSH? (SSH is the only form of access I will have to the server)

2. Is there a better way to remotely restore a server than what I outlined above?

3. Also, I've used the dd command to make backups before, but it copies an entire hard drive byte for byte. Is there an argument I can tag on, or another command to use altogether that will only copy the bits that are being used?

View 5 Replies View Related

Server :: MySQL Move Database / Server Doesn't Start

Nov 3, 2010

I'm trying to move a mysql 5.1.50-community InnoDB database from one location to another.When starting the service I get:Starting MySQL.Manager of pid-file quit without updating file [FAILED]I've searched for a way to do this but I can only find people who describe what I've just done.

View 6 Replies View Related

Server :: Slow Database Server On Processing / Make It Up?

Apr 15, 2010

I'm having trouble with my database server run with PHP & MYSQL; i just installed this system on a SUSE Linux Enterprise Sever; the Server its self is an HP Proliant ML370G with 4GB RAM
The system was fine for like 3 weeks until recently when it started slowing down. Apparently, eveything is normal when you are accessing the server, for example when you are browsing on the database web interface; but problem is when you start working in the database, when you try submitting into the database, its really slow on processing, i have to first restart the mysql;
Could it be RAM? or the SQL itself?

View 3 Replies View Related

CentOS 5 Server :: Put A MySQL Database In A Server's Memory?

Mar 18, 2010

I'm looking for a way to put a MySQL database in a server's memory. The disks aren't fast enough to keep up with the usage and I don't feel like going for a splitted web&db server yet because of the costs.

Because this involves risks (unless there's a way to read from the memory and write to the memory AND disks?), so I'd prefer that the DB gets copied automatically every hour or so to the local disks.

View 1 Replies View Related

OpenSUSE :: Postgres Does Not Start After Upgrade To 11.2?

Feb 10, 2010

I had postgresql 8.3 running on opensuse 11.0, recently upgraded to 11.2 (so postgres is now 8.4) and have problems starting it. I make, su, then as root run:

# /etc/init.d/postgresql start
Your databases are still using the format of PostgreSQL 8.3.
Therefore a backup of the old PostgreSQL server program will be used
until you have saved and removed your old database files
See also /usr/share/doc/packages/postgresql/README.SuSE.{de,en} .
Starting PostgreSQLsu: incorrect password

[Code]...

View 4 Replies View Related

Ubuntu :: What Is The Default Postgres Password?

Jun 23, 2011

I just installed postgresql 8.4 package on my Ubuntu 10.10 desktop. Seems to have worked fine. But what is the password for logging into the databases created by user 'postgres'?

sudo su postgres
and then
createdb
or
psql mydb

fine and it never asks me for a password. But if I want to use pgadmin3, I want to enter passwd for postgres, etc.

View 4 Replies View Related

General :: User Postgres Does Not Exist?

Jul 21, 2010

i have installed postgresql to my fedora10-distribution. when i would to access to this database by using the command #su postgres as is mentioned at [URL]..3/install/wiff/createcontext to install freedom , an error message is shown to tell me that user postgres does not exist. what is the likely problem.

View 15 Replies View Related

Software :: Autofill - Tab Key - Not Working In Postgres ?

Feb 24, 2010

I installed postgres successfully but, when I press tab key, it does not autofill the available options.

View 1 Replies View Related

Ubuntu :: Pgadmin On 10.10 - Support For Postgres 9?

Jan 16, 2011

I am in the process of looking to migrate my PC from Windows 7 to Ubuntu 10.10 as I like it and i find it a little quicker than Windows. One of the major failings I find at the moment is software app support. I am setting up some PostgreSQL 9.0 servers (to do streaming replication) and using pgadmin to do the management.

Under Windows this app works great, but under Ubuntu it seems the standard package only supports up to 8.4, and looks like support has been dropped for pgadmin on Ubuntu. What I can't understand is the open source movement isn't supporting itself - or is it that because 10.10 is not on LTS, they are waiting for the next version to update the package - anyone know? If its not supported then back to Windows I go, because I know the latest version works fine.

View 4 Replies View Related

Server :: Database Can't Use SSL Certificates?

Apr 19, 2011

I've installed PostgreSQL on Arch Linux & also self generated self signed certificates in /etc/ssl/ directory. My PostgreSQL 'data' directory is /var/lib/postgres/data & I've edited my postgresql.conf file to use SSL however I'm having permission / access problems starting my database using SSL. It can't access the certificates and errors out when I try and start the database engine:

Code:
LOG: autovacuum launcher shutting down
LOG: shutting down
LOG: database system is shut down
FATAL: could not load server certificate file "server.crt": No such file or directory
code....

I don't know what I need to chown or chmod in order to get PostgreSQL to access my self signed certificates.

View 3 Replies View Related

Server :: Create New Database From PHP / SQL

Nov 4, 2010

I am now able to create the database using PHP and SQL. But it seems I can only do it as MySQL root user.. $dbuser = 'root'; but is there a way to do that as a regular MySQL user?

View 2 Replies View Related

Server :: Sync One Database To Other?

Nov 8, 2010

I have got 2 postgresql databases on separate servers. i want to sync one database to the other. how it can be done ?

View 1 Replies View Related

Ubuntu :: Postgres Installed But Cannot Find Reference

Mar 24, 2010

Just bought a new accounting program BasicBooks - on the install instructions (Gibberish to me) I apparently must have Postgres installed, which apparently comes with most distros. I can't find a reference to Postgres - there should be an entry in 'System Settings --> Server Settings --> Services from the main system menu', which I cannot find. Nor can I find it in the Ubuntu software centre. I did find pgAdmin III but have no idea how this works either.

View 2 Replies View Related

Ubuntu :: Access Postgres Through A PERL Program?

Jul 25, 2010

I am very much interested in Postgres db.
I have installed the DBI and DBD drivers.
Created the Tables.
Can any one help me ..how to access POSTGRES through a PERL program.

View 1 Replies View Related

Software :: Testing A Postgres Dump File?

May 13, 2010

We are going through the motions of testing the backup and restore configurations of our postgres database. One idea was testing the viability of the dump file. Does anyone know of a way of testing the dump file to determine if there is any corruption in it

View 2 Replies View Related

General :: Monitor Database IO And Available Database Threads?

Mar 7, 2011

am using zabbix open source solution for systems monitoring. I am facing a problem and discussed it on zabbix forum. my post was as "My zabbix server is behaving abnormally, approximately daily from 9 to 12, the server stop accumulating logs. I observed that the server report is RUNNING but it did not accumulate log values and also the machine have no extra load. Its shown in the graph image attached.t the following reply,"database performance?are you monitoring database IO and available database threads? "So any one have any idea that how can I do this as I am using MySQL as backend database on RHEL 3.

View 1 Replies View Related

General :: Importing Database To Server

Apr 19, 2011

I switched from Windows 7 to Linux and when I'm trying to import my database i get error 1044. It used to work when I was using Windows 7. I was able to export the database from my localhost. However, when I try to import it to the other server I get this:#1044 - Access denied for user ' '@'%' to database'.I have been trying for hours to upload my site from the localhost to another server without any luck..I'm using phpmyadmin to import it.

View 2 Replies View Related

Server :: Cannot Create Database In PostgreSQL

Dec 26, 2010

i installed Fedora 14 on my machine,then i installed postgresql in it i started it and configured it after seeing link [URL] i am able to do su - postgres but when i am trying to create database in it am getting error,It is asking for password then i am giving my root password

createdb company
Password:
createdb: could not connect to database postgres: FATAL: password authentication failed for user "postgres"

View 1 Replies View Related







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