I've got a 80 MB sql_acii backup database from our previous crashed down open solaris pc. I am trying to restore it to the postgresql of Fedora 13 but this error appears:pg_restore [custom archiver] could not uncompress data: incorrect data checkpg_restore*** aborted because of errorProcess retured exit code 1
View 1 RepliesTrying to get OpenbavoPOS to connect to my remote Postgresql database, but so far i've only been able to connect to the local postgres installation. I _am_ able to access the remote databases with psql. I've read literally dozens of pages, and am pulling my hair out. I'm trying jdbc:derby.//192.168.15.10:5432/bravo I get back java.sql.SQLException no suitable driver found for jdbc:derby.//192.168.15.10:5432/bravo If I use jdbc:derby./root/bravo - all is OK, using a local database created in /root I have jdk installed on the client; does it need to be on the server also?
Server = CentOS 5.4 PostgreSQL version 8.1.21
Client = CentOS 4.8 PostgreSQL version 8.1.4
[code]....
I have recently Installed Fedora 11. I have installed postgres like yum install postgresql but I wonder there is no user created for postgres when I tried su postgres system says, no identity for user postgres. even when I tried to connect postgres server using psql then it says
Code:
psql: could not connect to server: No such file or directory
Is the server running locally and accepting connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
I have a problem configuring my PostGreSQL server for internal network access.
I want to be able to access my postgre server from 192.168.1.10
It works when I set listen_address to *, but if I input 192.168.1.10, or any other IP address, I always get:
Quote:
WARNING: could not create listen socket for "192.168.1.10"
FATAL: could not create any TCP/IP sockets
postgresql.conf section
[Code]....
what could this bei saved my correct iptables file @ Code: /etc/iptables.up.ruleswhere webmin is looking for it.webmin config is to automaticly boot this file and addes a line at.
Code:
/etc/network/interfaces
file
[code]...
I'm getting some problems setting up a Postgresql-8.4 server (using Debian Lenny).
After have installed the PGSQL server, I've changed the following files as bellow code...
If you encounter this message, please check if the server you're trying to contact is actually running PostgreSQL on the given port. Test if you have network connectivity from your client to the server host using ping or equivalent tools. Is your network / VPN / SSH tunnel / firewall configured correctly?
For security reasons, PostgreSQL does not listen on all available IP addresses on the server machine initially. In order to access the server over the network, you need to enable listening on the address first.
For PostgreSQL servers starting with version 8.0, this is controlled using the "listen_addresses" parameter in the postgresql.conf file. Here, you can enter a list of IP addresses the server should listen on, or simply use '*' to listen on all available IP addresses. For earlier servers (Version 7.3 or 7.4), you'll need to set the "tcpip_socket" parameter to 'true'.
You can use the postgresql.conf editor that is built into pgAdmin III to edit the postgresql.conf configuration file. After changing this file, you need to restart the server process to make the setting effective.
If you double-checked your configuration but still get this error message, it's still unlikely that you encounter a fatal PostgreSQL misbehaviour. You probably have some low level network connectivity problems (e.g. firewall configuration). Please check this thoroughly before reporting a bug to the PostgreSQL community.
This is the same configuration that I have in other Lenny server, which works well.
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"
when i give service postgresql status command. i get the following.ostmaster (pid xxxx xxxx xxxx xxxx xxxx xxxx xxxx xxxx xxxx xxxx xxxx xxxx) is running...The issue is my postmaster service is running in multiple process ids.As a result my cpu usage becomes high.How to resolve this. my postmaster service need to be run under only one process id
View 3 Replies View RelatedWe've been using a Wiki server at the office for years. It was originally configured to use MySQL and finally after 8+ years we're
moving the Wiki to a new platform of hardware. My question is the Wiki software (MediaWiki) is the only thing still tied to and using MySQL which we want to decommission but we've been using it for years so I'm worried we will lose the data. I've done some Google'ing to find out how can I change the MySQL database dump and successfully export it into my new PostgreSQL database however I don't know how practical or recommended this process is. I found sites like the following:
[URL]
I don't mean the exact link above but just in general taking a database from MySQL and successfully migrating it for PostgreSQL use?From what I can see in the MySQL database, there appears to be 43 tables with lots of column data and who knows what else:
Code:
mysql> show tables;
+----------------------+
| Tables_in_wiki |
+----------------------+
| dp_archive |
| dp_category |
| dp_categorylinks |
[code]....
I'm getting this error message every time I run updates.
Quote:
dpkg: dependency problems prevent configuration of postgresql:
postgresql depends on postgresql-8.4; however:
Package postgresql-8.4 is not configured yet.
dpkg: error processing postgresql (--configure):
[code]....
The following details are provided:
E: postgresql-8.4: subprocess installed post-installation script returned error exit status 1
E: postgresql: dependency problems - leaving unconfigured
For some reason I am unable to view my database tables for my Wiki & I can't understand what I am doing wrong or what I'm missing. I know for sure there's table data on my 'wiki' database but for some reason I don't know how to list it.
Code:
psql (8.4.5)
Type "help" for help.
[code]....
we have postgresql database in our server. when i tried to install our application it throws some error like "org.postgresql.util.PSQLException: ERROR: encoding UTF8 does not match locale en_US Detail: The chosen LC_CTYPE setting requires encoding LATIN1". the locale which is set in our server is
[code]...
I don't know how to approach to solve this error.
I had to rename a table yesterday due to a contact / group name change in the office and sadly I'm the only person who knows how to barely interact with SQL due to my years as a Linux Administrator. Renaming the table was simple:
Code:
iamunix=# ALTER TABLE accounts RENAME TO marketing;
ALTER TABLE
[code]....
This is my second day trying to learn opensuse. My lack of terminology makes it very hard to google for the answers. I need to do this:
opensuse:~ # yast2 install postgresql-server apache2 perl texlive perl-DBD-Pg libapr-util1-dbd-pgsql
I know about yast, however this looks like something that needs to ran from terminal.
I'm wondering how I start it automatically when I boot up the ubuntu 10.04? especially, when I created the user "postgres", I set a password to it. every time I issued "su - postgres" command, I need to give it a password.
View 2 Replies View Relatedmy database (PostgreSQL) has ever funtioned OK, but today don't let me insert a new row in a table and the record itsn't duplicated. I did a vacuum full and reindex the database and the problem continue. I don't know what the fuck is happening
View 2 Replies View RelatedI am trying to keep a VPN connection open between two Ubuntu 8.04 LTS servers, one in Holland and one in China. Unfortunately, because the connection in China is not great, about 1 time a day the connection drops. I have therefore devised a script, to be started by crontab once every 5 minutes, that checks the connection and if necessary restores it.
Code:
#!/bin/bash
ping -c 2 -W 10 10.10.10.73 &> /dev/null;
PING = $?;
[code]....
I have a dual boot system with Ubuntu 10.10 and Windows Vista. Today I upgraded Vista to Windows 7, and GRUB is no longer working. The usual problem, I know. Searched forums & Web and found many instructions for restoring GRUB manually or by using the Ubuntu Live CD.I tried the Live CD first. All the instructions say to boot to the CD, open a terminal, and enter: sudo grubI get an error message: command not found.Then I tried the manual method, which (after mounting the relevant partition) includes the instructions:
Reinstall the boot manager by typing "sudo grub-install --root-directory=/mnt/ /dev/sdX", replacing "X" with the Ubuntu drive's letter, and then hitting "Enter." For example, "/dev/sda" is the Ubuntu drive for most users.[This step appeared to work fine.]Then: Restart the computer into your Ubuntu system.Alas, the computer restarts to sh:grub and I don't know how to get from there to either Linux or Windows, or what to do to fix this problem. At this point I have no working system on that computer
I'm using Webmin, and Webalizer plugin. Days ago, webalizer works fine. But starting from yesterday, Webalizer no longer generate reports. And when I try to generate report manually using webmin, I get this message: Code: Running Webalizer to generate report from [URL]..
.. Webalizer failed! See the output above for details. Because I didn't get any details on that message, I run webalizer manually using command:
Code: # webalizer -n mydomain.com And as result, I got this message:
Code: # webalizer -n mydomain.com Error: Unable to restore run data (10) I have few domains in this machine, and for all domains I got the same result. Anyone has any idea(s) about what happened and how to cure it? Few days ago I think I tried to install Perl-Small-XML using CPAN and failed. And I installed awstats too. Don't know whether it's related or not.
When the power twitches, and X is displayed on the current tty. the display resolution is somehow lost. When the system is rebooted and X restarted, the resolution displayed (and the best offered) is 800x600.My resolution of choice is 1280x1024, and none of the configuration files appear to have been changed.The X resolution is unaffected if another tty was displayed at the time. (I am often working on two or three consoles as well as what X is using)In the past it has been sufficient to comb through the file system and delete all the temporary files and caches that seem to be associated with X. I have never been sure if this was actually any sort of solution to begin with, but in any case it no longer seems to work.
linux 2.6.35.0
Slackware64 13.1
Gigabyte: ga-p31-s3g
Intel q8400 (quad Core2)
Matrox g450 32mB (PCI)
I'm trying to recover my rpmdb after canceling the installation of a package (dumb, I know). After clearing /var/lib/rpm/__db* and running rpm -vv --rebuilddb I still get an error error: cannot open Packages index using db3 - Invalid argument (22). What should be my next step?
View 7 Replies View RelatedI was messing with some boot loaders which accidently disabled grub and I was remained with windows 7 boot loader only.How can I restore grub?I am using Opensuse 11.3
View 8 Replies View RelatedI used deja dup to backup my home folder today so I could restore it after reinstalling 11.04. now, it starts to restore, but gives me this error every time:
Code:
Calculated hash: ac14ae0a7bf52c1ea0d851cec864df9e1c06b54e
Manifest hash: 4173054c0b0c8ce1154af5b5caae2a7591652765
Have been using mint 11 for past few weeks with no problem but failed to boot correctly. menu appeared giving options for booting but kept returning to this menu without going further so I opted to go for safe booting option, after loading a few files it asked for password but kept giving me the message incorrect password so I could get no further. Fortunately I had a cop of clonezilla and was able to restore a backup from a second hard drive but would be grateful for any observations anyone would like to make about this (in case it happens again)
View 3 Replies View RelatedI used Ping Linux 8 months ago to create a ghost-like image of my primary partition. (Windows 7 on NTFS) The image is on the second partition of my hard drive (Western Digital 250 gig). I need to restore now, but Ping is unable to mount the volume. In fact, it will not mount any volume or perform any new backup. I made sure nothing has changed in Bios options since I created the backup. Does this imply that is not the appropriate tool to work on NTFS system?
View 4 Replies View RelatedI'm trying to install postgresql 8.3 on Ubuntu 8.04 LTS server and I'm running into problems starting it. Commands I've done # apt-get install postgresql postgresql-common Things I've tried Starting it manually
# /etc/init.d/postgrsql-8.3 start
Nothing appears in my /var/run/postgresql When I try and start psql as the postgres user I get the following error psql: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"? I've been following the docs at: https://help.ubuntu.com/community/PostgreSQL
I installed 10.10 on my machine a few months ago and everything was great. However, as of one month ago, every so often when I boot up my computer I get no sound in Ubuntu. This is not an easily reproducible error, as far as I can tell, but is a pain to fix. The previous times this happened I messed around, tried some commands shown in other help threads, and then eventually re-adjusted the "Profile" setting for the output devices in the "Sound Preferences" utility, which brought back the sound. I have never conclusively been able to determine the source of the problem, or how to resolve it. Now it is happening again and I have been unable to restore the sound with my primitive methods.
I just came back to the tiny village where I live to be near my workplace, and am missing my family - I just want to eat my dinner and watch some Buzzcocks with sound* - can anyone help please? Ideally I'd like to identify the source of the problem, fix it, and make sure it does not happen again.
During my travels of the forums I came across a troubleshooting script thing which I ran. The output, if it is of any use, is located here:[URL]...*Alright, this is a bit melodramatic, but the alternative is booting up in Windows, and no-one wants to see that happen,
After completing the installation of Fedora-FEL edition, I cant boot from my hard disk. "No bootable device found " error appears.
I have one Windows XP & 2 Linux installation in my disk.
I tried to restore grub using "setup (...)" command.but same error repeats.
Even I cant restore Windows XP using "fxmbr" command in... recovery console .
But I can boot from that drive by "chainloader" command in grub. code...
Running above command in grub terminal boots my hard disk ("hd1" is my "unbootable disk")
I used Clonezilla an older version not the latest to backup an entire NTFS Windows XP drive to DVD last year. I have a series of three (3) of these DVD's but now cannot restore the backup image back to the same PC. The problem is that when booting with Clonezilla I don't have an option to restore from a CD or DVD drive since the computer comes with two working CD/DVD drives that are detected by the BIOS when the POST is displayed. I used one of these drives to boot with Clonezilla and the other one containing the backup image Disk 1 of Disk 3. Clonezilla only detects the two hard drives and a USB drive which is removable. Is there a bug in the restore process because it allowed me to backup the entire image of the hard drive onto a DVD last year but this time around there are no CD or DVD drive options available to choose other then the CD drive Clonezilla was used to boot up.
View 8 Replies View Relatedare there any sweeper / cleaner apps which can take back my installation as to when it was new. I know home directory could have config files etc..but that doesnt matter, i want all packages and applications reset to how it was when i had a clean install. I am using Natty
View 2 Replies View Related