You can technically just copy & paste the postgresql data directory IF YOU
SHUT DOWN THE POSTMASTER FIRST! Be aware that this will only work for the
same version of postgresql. Also: this is not a good way to do it and I'd
encourage you not to use this as general means of backup (it's ok if you
On windows the database files are under C:\program files\postgresql\8.1
\data
There are a number of different ways a backup can be done and a file
level copy/paste is one of them.
See http://www.postgresql.org/docs/8.1/interactive/backup.html
Mike
On Sun, 2006-07-02 at 11:01 +0700, Joko Siswant
> I'm new bie in postgresql.
> I use postgresql 8.1 windows version.
> How to back-up database in postgresql? Usually i use pgAdmin III by back-up
> and restore.
> Is there any way to back-up database like mysql or sql server we just copy
> and paste. Or maybe there is any tools to copy database wh
Hi all,I'm new bie in postgresql. I use postgresql 8.1 windows version.How to back-up database in postgresql? Usually i use pgAdmin III by back-up and restore.
Is there any way to back-up database like mysql or sql server we just copy and paste. Or maybe there is any tools to copy database when the
Hi Dave,
Documentation such as this can be added to the new techdocs area on the
main site at http://www.postgresql.org/docs/techdocs under the relevant
section (probably http://www.postgresql.org/docs/techdocs.3 in this
case).
Please note that the editting interface is still new and may still
In an attempt to throw the authorities off his trail, [EMAIL PROTECTED]
("Merlin Moncure") transmitted:
> hm. that's all very true (and important), but I try and keep focus
> on the things besides basic correctness that drive the development
> cultural divide that seperates the two communities. p
On 6/30/06, Jim C. Nasby <[EMAIL PROTECTED]> wrote:
Actually, PITR is in no way analagous. Try replicating something like
'INSERT INTO table SELECT random();' on MySQL and note how all the data
is different.
pgpool replication is equivalent to MySQL's replication. Or if you want
more sophisticat
"Tomi NA" <[EMAIL PROTECTED]> writes:
> Basically, it comes down to three possibilities, doesn't it:
> 1.) use an existing library
> 2.) write a pgsql specific implementation
> 3.) forget about it and tend to other issues
> Personally, I don't really care if it's 1) or 2): I'm just afraid it's
> g
On 7/1/06, Martijn van Oosterhout wrote:
On Fri, Jun 30, 2006 at 07:29:12PM +0200, Tomi NA wrote:
> If I sound harsh, please excuse me, but I feel like I'm the only one
> who thinks these encoding problems (collation, upper/lowercase,
> multiple languages in a single database) are serious...nobo
Thanks that is basically what I was looking for I will investigate further.
I appreciate your response.
Thank you for your time,
Jason Long
CEO and Chief Software Engineer
BS Physics, MS Chemical Engineering
http://www.supernovasoftware.com
HJBUG Founder and President
http://www.hjbug.com
-
> I was hoping for something a bit more automatic with less maintenance from
> me. Thank you for your reply.
> On 7/1/06, Jason Long <[EMAIL PROTECTED]> wrote:
> >
> > Is it possible to define a function or view that performs fairly intensive
> > calculations and then index or cache these results?
2006/7/1, Tom Lane <[EMAIL PROTECTED]>:
"Clodoaldo Pinto" <[EMAIL PROTECTED]> writes:
> There is a simlink in /var/lib/pgsql/data pointing to /disk2/pg_xlog
> which is in sbd1 and is owned by postgres.
You need to modify the selinux policy to let the postmaster access
/disk2/pg_xlog ... by defau
I was hoping for something a bit more automatic with less maintenance from
me. Thank you for your reply.
Thank you for your time,
Jason Long
CEO and Chief Software Engineer
BS Physics, MS Chemical Engineering
http://www.supernovasoftware.com
HJBUG Founder and President
http://www.hjbug.com
---
Is it possible to define a function or view that performs
fairly intensive calculations and then index or cache these results?
The data I have will be accessed more than modified, but
still will be modified semi regularly.
Would someone please enlighten me on my options for
improvin
"Clodoaldo Pinto" <[EMAIL PROTECTED]> writes:
> There is a simlink in /var/lib/pgsql/data pointing to /disk2/pg_xlog
> which is in sbd1 and is owned by postgres.
You need to modify the selinux policy to let the postmaster access
/disk2/pg_xlog ... by default, it's constrained to only be able to to
Postgresql does not start on reboot but starts normally with "pg_ctl
start". Running FC5 with selinux enabled.
# chkconfig --list postgresql
postgresql 0:off 1:off 2:on3:on4:on5:on6:off
/etc/selinux/config:
SELINUX=enforcing
SELINUXTYPE=targeted
SETLOCALDEFS=0
In /var/
On Saturday 01 July 2006 09:08, "Alain Roger" <[EMAIL PROTECTED]> wrote:
> it works but i get all fields from my accounts table.
>
> So how can i get only login and status ?
>
Define a composite type that includes only those fields and return SETOF
that_new_type instead of SETOF accounts.
Or sel
On Sat, Jul 01, 2006 at 12:49:45PM +0200, Philippe Lang wrote:
> Hi,
>
> Is there a way to use a graphics drawing library (like GD for
> example) inside a plperl function, and "stream" the result image
> (bytea column?) without storing anything to the disk or database?
> Has anyone done that befor
Hi,
I have the following stored procedure :
CREATE OR REPLACE FUNCTION immense_sp001(IN username VARCHAR, IN
strhash VARCHAR)
RETURNS SETOF accounts LANGUAGE plpgsql
AS '
DECLARE
Profile_Detected INTEGER :=0;
act accounts%ROWTYPE;
rec RECORD;
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
a wrote:
> hi
> i want to know
> how to add a list of items to a database
> it is basically text, but different fields
> but the problem is i dont know how many fields are there before hand
>
> so i m not sure how to store them in the db
> sometime i
"Merlin Moncure" 寫道：
> On 30 Jun 2006 08:58:27 -0700, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> > I am new to pgsqlI really appreciate the licensing terms of
> > pgsql...mysql licensing is a little bit risky to use...
> >
> > Q. when using pgsql as a very heavy and mission critical appli
hi
i want to know
how to add a list of items to a database
it is basically text, but different fields
but the problem is i dont know how many fields are there before hand
so i m not sure how to store them in the db
sometime i need to store 10 elements and some other times 5
thanks a lot
a
--
On Fri, Jun 30, 2006 at 07:29:12PM +0200, Tomi NA wrote:
> If I sound harsh, please excuse me, but I feel like I'm the only one
> who thinks these encoding problems (collation, upper/lowercase,
> multiple languages in a single database) are serious...nobody seems to
> share the sentiment. Ah well..
On Fri, Jun 30, 2006 at 11:26:06PM -0400, Tom Lane wrote:
> Something that would actually hold some intellectual interest is to
> improve the testing infrastructure. The current setup is pretty limited
> as to its ability to deal with varying outputs, and even more limited
> in its ability to test
Hi,
Is there a way to use a graphics drawing library (like GD for example) inside a
plperl function, and "stream" the result image (bytea column?) without storing
anything to the disk or database? Has anyone done that before?
Thanks,
---
Philippe Lang
Attik System
smime.p7s
Desc
25 matches
Mail list logo
