How to drop all connections to a specific database in postgres without stopping the server?

Let’s learn how to drop all connections to a specific database in postgres without stopping the server. The most accurate or helpful solution is served by Database Administrators.

There are ten answers to this question.

Best solution

How to drop all connections to a specific database in postgres without stopping the server?

I want to drop all connections (sessions) that are currently opened to a specific postgresql database but without restarting the server or disconnecting connections to other databases. How can I so that?

Answer:

Here is my answer to very similar question on StackOverflow. Depending on your version of postgresql...

Read more

sorin at Database Administrators Mark as irrelevant Undo

Other solutions

Technology and design patterns for x-platform app?

I'm going to take the plunge and build, frankly, an insane application. I won't get into the nitty gritty, but suffice it to say it's a "world builder" app. I am just starting to figure out what I'm going to need, tech-wise, to build this thing...

Answer:

OK, so this is a lot to take in, which is why you haven't had any responses, I think. So you want to...

Read more

symbioid at Ask.Metafilter.Com Mark as irrelevant Undo

What can be done about the unreliable nature of TCP?

When I check email or when I'm browsing the web, I find that at times it's actually faster to stop/abort the page load and start again.  This is especially true when doing this over a mobile network.  A check of email can take a long time if there is...

Answer:

I disagree with the premise of the question; TCP, by nature, is remarkably reliable.  However, as you...

Read more

Phillip Remaker at Quora Mark as irrelevant Undo

ASP.NET Access database connections to a web server

I am trying to make an Access Database connections on a web server. I've developing an ASP.NET application that will need to access data that will reside on a web server. I currently have service with nexpoint.net and am trying to make a connection with...

Answer:

Hi mikeg, Here is a detailed document from Microsoft about how to create a connection using OleDbAdapter...

Read more

mikeg-ga at Google Answers Mark as irrelevant Undo

Is there a way to fix this problem with my PostgreSQL database/server?

I seem to have had PostgreSQL version 9.1 installed on my Mac (maybe it was included automatically). However, after I updated to 9.2.3, i got this error in the logs. I can't figure out from the docs what I should do in this situation from the logs FATAL...

Answer:

Use pg_upgrade. Different major releases of PostgreSQL (e.g. 9.1 vs 9.2) are usually binary-incompatible...

Read more

Hadi Moshayedi at Quora Mark as irrelevant Undo

Definition of sql server, database engine, dbms and how they all work?

At work(I'm new) I have to use sql server 2008 R2 and from there connect to a server. Databases can be seen once opened. I use a client program(company program)which asks you to enter a database and a sql server name and am a bit puzzled.I assume databases...

Answer:

Absolutely. The above statement is correct. Your client application that connects to a given database...

Read more

fashionw... at Yahoo! Answers Mark as irrelevant Undo

Running multiple web servers and database replication; any ideas?

Working on finding a solution to a particular problem we have at the office,we have a web host and at times our web server (Apache) crashes; which causes our web app to be unavailable to users. Usually as a result of the number of users, we noticed that...

Answer:

A few ideas: 1. Optimize your SQL queries 2. Use caching (Memcached perhaps) 3. Add some indexes to...

Read more

Andrew Clark at Quora Mark as irrelevant Undo

Server/Network/Database? Not sure what I need for small office?

Hi I am setting up my own business I am in the process of deciding how to set up a small office. I am trying to create a database for Product, Customer, Orders, Employees etc. When I move into the office would the best option be to have the main server...

Answer:

It really does not matter where you choose to house your data. Just make sure that a) it's secure, b...

Read more

Kim at Yahoo! Answers Mark as irrelevant Undo

How big should be a dedicated webserver and database with around 5000000 customer records and their financial records for an online payment application? I need exact specification of server and database. How much the webserver and database would cost?

I am thinking of developing and on line payment application for a particular business. The business idea is briefly following - There are multiple companies which provides a particular service, say Service A to their customers. Each of these companies...

Answer:

IF (and this is a big if) 100,000 customers paid an average of 1 bill through your system every month...

Read more

Rick Fritzler at Quora Mark as irrelevant Undo

SQL Server database security?

I'm using my computer as a server on a local network and I have sql server 2000 database installed..the problem is when I keep my computer turned on, anyone can access the data in the database..I don't know how to fix this..I don't know how to add login...

Answer:

Right click on your desktop choose properties then the screensaver tab and check On resume, password...

Read more

what goes around comes around at Yahoo! Answers Mark as irrelevant Undo

Just Added Q & A:

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.