how to take PostgreSQL backup in local driver and restore also.please tell me easiest way of backup & restore.
Hi, I am using JDBC to connect to a Postgres DB. I am calling a method that connects to the DB twice. It connects once to do a select statement and another time to do an insert statement. I am …
Hi, I have been getting an error in my java web application "No suitable driver found for jdbc:postgresql://...."
This is a maven java web application. The jar is included as a dependency in the …
Now i am using Postgre sql in one machine.more than 3 person want to access this postgresql database.So each & everytime login that postgresql machine.So can you please suggest application …
I found this command for solving the lock file "postmaster.pid" already exists in postgresql
You could stop your server doing :
pg_ctl -D /usr/local/var/postgres stop
Where did the …
I am using Navicat and I (finally) have Postgresql running.
I accept defaults as
Record delimiter LF
Text qualifier " (there aren't any - maybe there should be)
So I make both date …
I have installed Postgresql 9.6.1 in my desktop machine.If i open the pgadmin it show error"Failed to connect to the pgAdmin application server. Click here to try again."
After click …
I had this question after viewing Installing Navicat postgreSQL on a local Mac (https://www.experts-exchange.com/questions/27206594/Installing-Navicat-postgreSQL-on-a-local-Mac.html).
Anyone know …
SQL Novice here. Mac 10.12.13 I have Postgres installed as the one that comes with mac and Navicat on 14 day trial. Not worked out how to use either., but these are not my questions.
This is, can …
After searching I am surprised there doesn't seem to be any discussion about this.
I have navicat with two days remaining on trial. I have no idea if it suits me or not, being a …
Continued from here (https://www.experts-exchange.com/questions/29004649/Awk-Pythagoras-applying-csv-file-data-to-the-problem.html?anchor=a42033886¬ificationFollowed=185186068#a42033886) because …
Simple question and I still can not find exact answer anywhere on the web.
So I have Jira system. It's not big (20 users). It uses PostgreSQL database. Can I use pg_dump while the system is online?…
I got a Database link from Oracle 10gR2 to Postgre 9.5 and i'm having an issue when trying to run a few commands.
I executed a few queries from pl/sql and it works sometimes but sometimes…
I had this question after viewing Backup and Restore VCenter Linux Appliance methods and scenario best practice ? …
Do we have any techniques or tools to convert ER to Activity diagram.
If so, how?
I have a VB .Net application which talks to a backend PostgreSQL database.
I'm using NpgSQL to run queries against that database.
In order to get better performance for bulk inserts into the …
For a small company, I would like to find a simple inventory management software. Requirements:
- easy to use
- web client
- MySQL/PostgreSQL storage
Nice to have:
- phone client/app
I create "idprice" field and I want to reuse it is it possible
[Err] ERROR: column "idprice" does not exist
The database has about 4.5 million rows across 16 tables.
I ran the script below in the Query Tool under Views and is succeeded in 3 seconds.
I then clicked on address_view and then View Data and …
I ran this script and it appeared to run correctly apart from one line:
ALTER TABLE ADDRESS_ALIAS ADD
CONSTRAINT ADDRESS_ALIAS_PK PRIMARY KEY (address_alias_pid);
ALTER TABLE …
Hi there ,
Does anyone know if you can look into whether we can do the following on the stock control page in wordpress searches of stock:
They are using a vehicle search here …
how can I select from 09:00 to 09:29 become a
and 09:30 to 09:35 become a
Generally speaking, it is better to make lots of frequent queries on a db (that pull a small amount of data), or less frequent queries on the db (that pull a large amount of data). I don't want to …
In code line 14 i want to put table name into field filname but this code put all column in each row to filed filname how cani fixit
trunc(EXTRACT(hour from "public".pong8_maintable."timestamp8") / 7) as sectionid
make column type double precission but i want only integer how can i change it