Dario Pudlo wrote:
Problem: Not being able to restore a database with lo. I have already read
forums and doc. Probably I'm loosing something, but I just can figure.
Reading forums I though I finally got a "right" way to do it.
I'm running this as OS user "postgres" which is a super user
pg
Hello,
First of all, sorry about my english. I'm searching a tool for
implementing a distributed DB in postgres. I've found "pgreplicator"
(http://pgreplicator.sourceforge.net/). I figure out that the last
revision of the project was in 2001, and I don't know if the project
goes on.
I have
Hello,
First of all sorry about my bad command of english.
I have two questions about postgres.
First.
I have a Linux box with postgres 7.4 branche, where web php applications
queries the DB. When Apache launches a php file that connects to the DB,
if I do "ps aux | grep postgrest", I can see
Michael Fuhr escribió:
On Mon, Apr 17, 2006 at 09:42:59AM +0700, [EMAIL PROTECTED] wrote:
Now I have 3 database A,B,C is working in Interbase v 5.6,
but Interbas v 5.6 is no longger can hold what the client wants,
Sure ?
Before thinking to change the database, have you test firebird da
kbd wrote:
I have many years experience with several database products: Foxbase,
FoxPro, MS SQL, Access, Postgresql, AS400 DB2. Compared to any of the
above Access is a toy. Case in point; in my office we have a product
which is "multi-user" based upon Access. When the users, there are
only fo
What happends with http://www.postgresql.org ?
When I try to connect to this URL, the download stops.
The only avalaible version of Postgres website that I can find is
http://www.postgresql.com, that is a comercial site.
Thanks.
---(end of broadcast)
servers,
so it isn't network related ... browser?
On Wed, 5 Nov 2003, Juan Miguel wrote:
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Hi, I use MS Visio Professional, and it works (not very good), but it works.
I ever wondered if there is a opensource tool, that let me create an
automatic ER-Model diagram from an existing DB, like MS Visio.
Do you know if this tool exists ?
Thanks
Hi Tony,
TR> It occured to me that perhaps pr
You can kill the procs (connections) using kill -9 PID
For example,
ps aux | grep post
gives you a list of the postgres processes (all the active connections,
and main postmaster). Here you can see the IP of the manchines connected
from.
Therefore, its easy to create an shell script for killin
'kill -9' PID will force all backends to flush cache for no good reason.
Note that on most unixes, a plain kill PID will send the term signal,
which tells the process to poltely shutdown and release resources. kill
-9 is like using a sledge hammer to swat a fly for this.
-
Can PostgreSQL use multiple processors if they are present in a
computer, and if so, how much will it speed up database server? Tnx in
advance.
Linux OS, can explode multiprocessors servers, therefore, each session
on postgres (a session = a process), can be allocated in a processor.
Mult
This is a little question :
In postgres, "delete database dbsample", frees the disk space used for
this DB?, or I have to drop the files manually ?
I wondered this question, because I read that when you delete records,
you must run vacuum for freeing the space.
Thanks.
Peter Eisentraut wrote:
Am Freitag, 15. Oktober 2004 08:37 schrieb macdickson:
Can any one tell me how to store jpegh files in Postgres Database
Use the data type "bytea".
First, Sorry about my english.
I use the "lo" type (see contrib folder). This is similar to oid type,
but helps you
Francisco Jose Bernabe Pellicer wrote:
What folder in Linux is used to store Postgres Databases?
Cheers,
It depends on your compilation or your Linux, Windows, e.t.c.
distribution packages installed.
For example, if you compile by yourself the source code, the default
directory is usually /usr/lo
I suggest that you try with Postgresql 8. It's already in beta phase,
but is Windows native, and does not need cygwin.
The performance of postgres with cygwin is poor.
Hi
I have been trying to get postgres in windows through cygwin. No
success yet. I followed all the instructions in postgresql-7
Michael Fuhr wrote:
On Mon, Mar 21, 2005 at 05:12:52PM +0100, [EMAIL PROTECTED] wrote:
I have a table where an oid field is used for saving images. I'm thinking
about getting a little snapshot of all images without downloading the full
images. I only want to download some entire images. I'm thin
Dario Pudlo wrote:
Problem: Not being able to restore a database with lo. I have already read
forums and doc. Probably I'm loosing something, but I just can figure.
Reading forums I though I finally got a "right" way to do it.
I'm running this as OS user "postgres" which is a super user
pg
I know it would be a hard approach but... perhaps ON DELETE and ON UPDATE triggers would help?
On 5/11/05, Jay A. Kreibich <[EMAIL PROTECTED]> wrote:
On Wed, May 11, 2005 at 03:51:43PM -0400, [EMAIL PROTECTED] scratched on the wall:
> I would like to clarify something.> I intend to create the datab
Greetings, all!
As described in
http://www.postgresql.org/docs/8.0/interactive/datatype.html#DATATYPE-SERIAL,
column "type" SERIAL is really an integer type with an implicit
sequence associated by default with that column. In order to get the
last generated value from the sequence, use the "currv
On 9/26/06, Jeanna Geier <[EMAIL PROTECTED]> wrote:
Hi All-
I am hoping for some help on this one... we are in the process of
implementing our program with SSL enabled on the Postgres side of things. I
can start and connect to the database from the command line ok using my
current configuratio
On 9/26/06, Jeanna Geier <[EMAIL PROTECTED]> wrote:
Hi and thanks so much for the replies!!
I had perused that doc and google prior to posting and didn't have any luck;
what I tried was the following:
added:
private static final String DB_SSL_STATUS = "true";
&
prop.setProperty("ssl", DB_SSL_ST
Hi, folks!
Due to a hardware (hard disk) problem, we've tried to restore a
postgresql filesystem backup (taken from what was left on the drive)
to a fresh Postgresql install (as stated in
http://www.postgresql.org/docs/8.1/interactive/backup-file.html),
checking the appropiate ownership, privilege
22 matches
Mail list logo
