0
votes
1answer
33 views

Metasploit wouldn't work with the database

I am running Arch Linux on my i386 laptop. I've made a fresh install of ruby1.9 and metasploit from AUR and now I'm experiencing some weird stuff with it. First, it does not load any modules upon ...
0
votes
0answers
60 views

iptables configuration on Windows Azure (CentOS 6.5) for endpoint load-balanced set

I created 2 VMs (CentOS6.5) on Windows Azure for Postgresql database and HA cluster, everything works fine except when I set iptables service on, the endpoint load-balanced set is down. for security ...
0
votes
1answer
27 views

How to create a database from psql user (not linux user)

I' ve studied some PostgreSQL. In the principle i' ve been teach to create a postgress's user with same name of my linux's user. Now i want to try to make an application, and for this reason i would ...
0
votes
1answer
58 views

Can I tell if crashplan has backed up a particular file in a particular state?

I would like to be able to tell, programmatically, if CrashPlan has backed-up a particular file, including the current updates to that file. I.e., that the current contents of a file are backed up. ...
0
votes
1answer
41 views

A few doubts about creating my own webhosting server

I just created a system administration website from scratch for one of my university's administration offices (for free) using a postgresql database. I have tested this new system for almost 3 weeks ...
0
votes
1answer
274 views

How to configure PostgreSQL for best access from both Windows 7 host and Ubuntu 12.04 guest?

I have a new Ubuntu 12.04 installation freshly installed on VirtualBox, which in turn is running on a 64 bit Windows 7 machine with plenty of RAM. I would like to install PostgreSQL on this system in ...
2
votes
2answers
95 views

Install postgres without apt-get

I have access to a machine on a scientific hpc, and I'm setting up an environemnt to create a web application, made up basically of TOMCAT and postgresql. I cannot use another web server. The OS is ...
0
votes
1answer
3k views

ubuntu 13,10 “Failed to download repository information”

I have ubuntu 13.10- 64 bit version on my machine.recently i tried to install postgres for ROR development but i couldn't complete the postgres installation and found that my update manager always ...
2
votes
1answer
36 views

Why does `psql --file` misinterpret tilde?

Earlier I used pg_dump to create a database backup in my home directory called book_dump.sql. I want to restore the backup to an empty database called book. To restore the backup, I tried this ...
0
votes
0answers
27 views

Attach a new EBS volume to an existing EC2 db server instance

I had a micro instance of EC2, wherein I put my PostgreSQL database server. The EC2 instance came with the default Block Store. As of now, I want to attach a new Block Store to the existing EC2 ...
0
votes
1answer
66 views

Copying File From One User To Another

So I have this file stored in my account. It's postgres dump. To be able to use postgres it seems that I have to execute the following command. sudo su - postgres Once I do this I am now working as ...
1
vote
1answer
274 views

Need Tool to Extract ER Diagram fom PostgreSQL 9,1

Guys I need to compare 2 different databases running in PostgreSQL. I would like to use some tool to extract the diagram in a automatic way, Ive tried pgadmin3 and pgdesigner but they seem ...
0
votes
1answer
393 views

How to configure bi-directional replication on a single table in symmetricDS?

I have installed and configured the database replication software from http://www.symmetricds.org/ on the client and the server. I have followed the directions to setup the example replication, and ...
0
votes
1answer
437 views

Exception while configuring symmetricDS with postgresql on Linux

SymmetricDS is a java tool which can replicate databases and tables across an intermittent internet connection. I am having trouble configuring it to work with postgresql. I am doing this piece of ...
0
votes
3answers
83 views

Linux equivalent to Windows error code 3010?

I am fairly new to error codes and was trying to figure out an equivalent error code to Window's error code 3010 which states that an installation succeeded but requires a reboot. I tried looking ...
0
votes
2answers
270 views

Postgresql on linux ami

I'm a newbie to aws and postgresql I've launch an instance with quick wizard of linux ami 2013.03.01 It says that the instance include a repository access to postgresql - I thought that means that ...
0
votes
2answers
202 views

redirect output from rpm -Uvh postgresql91-*.rpm

I have a bash script to install postgresql part of the script contains this command rpm -Uvh postgresql91-*.rpm i need to direct ALL the output generated by this rpm command into a log file FROM ...
0
votes
1answer
590 views

How to recompile the PHP with --with-pgsql

I have installed the postgresql, php and apache to Amazon Linux AMI. Now I want to use the phpPgAdmin, it prompts "Your PHP installation does not support PostgreSQL. You need to recompile PHP using ...
1
vote
1answer
458 views

apt-get fails at everything in Ubuntu due to postgresql error - how to fix?

I've got a server with zoneminder, mysql, ffserver and some ffmpeg instances running on it, but for some reason everything seems to be tied to PostgreSQL. I noticed an error when loading the ...
0
votes
1answer
206 views

How to calculate max_connections for PostgreSQL and default_pool_size for pgbouncer?

Is there a rule or something I can use to calculate a good number for max_connections, default_pool_size and max_client_conn? The defaults are odd. PostgreSQL defaults to max_connections=100 while ...
0
votes
1answer
262 views

rsync fails under daemon but succeeds when run from terminal

I have script [1] that is executed by Postgres daemon (WAL archiver) and fails with exit code 12; see [2]. But if I execute the same script on a terminal/ssh session, it succeeds; see [3]. User ...
0
votes
2answers
8k views

Setting up PostgreSQL gives error sudo: initdb: command not found

Step 1: I installed PostgreSQL using sudo apt-get install postgresql-9.1 as recommended on the PostgreSQL website Step 2: I tried to run postgres. It's not found. For whatever reason, the install ...
4
votes
1answer
67 views

Is password required for restricted database servers [closed]

I have a dedicated Database server which is have PostgreSQL 9.1. This server has firewall. Only 10.0.0.3 is allowed to connect and access to this server via Firewall. All other requests from other ...
1
vote
1answer
3k views

How to change root password for PostgreSql phpPgAdmin?

What is the simplest way to change root password for PostgreSql phpPgAdmin ?
1
vote
1answer
92 views

How can I build an old application for 64bit?

I am trying to build postgresql 7.4.6 on a 64bit machine for 64bit. I'm not sure whether this code is 64bit compatible. Is there a way to check? If it is 64bit compatible, do I need to do anything ...
1
vote
2answers
78 views

How to I change the path when I log in as a new user in ubuntu?

I am running ubuntu on a flash drive. The default log in is "ubuntu". I installed Postgresql and created a new user called "postgres". However, when I switch to postgres with "su postgres", the ...
0
votes
1answer
992 views

Why pg_dump 'trust' authentication fails under root and works under another user?

I have pg_dump command in cron that accesses PostgreSQL under user postgres and does not provide a password. pg_dump --username=postgres ... I have set in pg_hba.conf that user postgres should be ...
1
vote
1answer
3k views

XAMPP with PostgreSQL

I'm looking for a package like XAMPP, but instead of MySQL it would use PostgreSQL. I've done some searching and haven't turned up anything other than doing a full server setup of both.