You can get the details at -->
http://www.postgresql.org/docs/8.2/static/backup.html
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 2/13/07, RPK <[EMAIL PROTECTED]> wrote:
We are planning a mission-critical client/server application and want to
use
PGSQL as backend to VB.NET. Before des
We are planning a mission-critical client/server application and want to use
PGSQL as backend to VB.NET. Before designing I want to test all the backup
and recovery options available in PGSQL and also options with which we can
recover from PGSQL service failure.
Where I can find all the back/reco
"dfx" <[EMAIL PROTECTED]> writes:
> How I can recreate (replicate) the same structure of a database originally
> made with pg v. 8.2 to a server v. 8.1?
pg_dump has never been intended to produce backward-compatible dump
scripts; in most versions it's easy to point to cases where it'd be
flat-out
Dear Sirs,
I am trying to create a database in postgres v. 8.1 (Fedora core 6) using a
sql script created from pg version 8.2 (Windows) (using backup.text of
PgAdminIII) but I get an error with the keyword OWNED. (tables uses serial
type).
The fields with serial type are declared differently in t
> >> So what happens if you have an old os with a new postgresql install?
> >> Will CURRENT_TIMESTAMP always return the correct value even if the
> >> system 'date' command is showing the wrong time?
>
> > Yes.
>
> Unless the user changes the system's clock setting (ie, its notion of
> the curr
Shoaib Mir wrote:
pg_stat_all_table view should help you:
select last_autovacuum, last_autoanalyze from pg_stat_all_tables;
select last_autovacuum, last_autoanalyze from pg_stat_all_tables;
last_autovacuum | last_autoanalyze
-+--
|
...snip lot
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
pg_stat_all_table view should help you:
select last_autovacuum, last_autoanalyze from pg_stat_all_tables;
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 2/9/07, Sic Transit Gloria Mundi <[EMAIL PROTECTED]> wrote:
Hi,
I couldnt find this on google, the archives, or the manual. But wit
Sic Transit Gloria Mundi <[EMAIL PROTECTED]> writes:
> I couldnt find this on google, the archives, or the manual. But with the
> changes to what the autovacuum daemon logs, how can we verify it's doing its
> thing? Is there a way to query the last time a table was vacuumed? But I
> don't see
"Phil Endecott" <[EMAIL PROTECTED]> writes:
> - Can anyone offer a list of which commands are compatible with
> PQexecParams and which aren't?
Plannable queries can take parameters: SELECT/INSERT/UPDATE/DELETE.
Utility commands (which is everything else) don't do any expression
evaluation and thu
"Anton Melser" <[EMAIL PROTECTED]> writes:
> ERROR: operator is not unique: boolean = integer
> I get this whether castcontext is 'a' or 'i'.
If you make both cast directions the same priority then the system has
no basis for choosing bool = bool over int = int or vice versa. Try
making one dire
Bruce Momjian <[EMAIL PROTECTED]> writes:
> Joseph Shraibman wrote:
>> So what happens if you have an old os with a new postgresql install?
>> Will CURRENT_TIMESTAMP always return the correct value even if the
>> system 'date' command is showing the wrong time?
> Yes.
Unless the user changes th
Joseph Shraibman wrote:
> Robert Treat wrote:
>
> > If you are running pre-8.0 versions you need to update your operating
> > system
> > (as you indicated). If you running an any 8.x version, you need to be on
> > the
> > most current corresponding 8.x.y release.
> >
> So what happens if you
Hi Melvin,
Here is a slightly optimized version of this function
It returns the exact same results, just runs about 1000x faster.
I've also marked it as "immutable", that's probably what you wanted,
not Volatile.
select all_prime(1,11000)
-- Total runtime: 2868.264 ms
select all_prime
Thanks Magnus,
Now I am passing the line thus pg_hba.conf
##
hostall all 10.193.4.0/24 ldap
ldap://ldap.cb.sc.gov.br/dc=cb,dc=sc,dc=gov,dc=br
##
However error in login is occurring
% psql postgresql -h server -U scott -W
psql: FATAL: LDAP authentication fa
Robert Treat wrote:
If you are running pre-8.0 versions you need to update your operating system
(as you indicated). If you running an any 8.x version, you need to be on the
most current corresponding 8.x.y release.
So what happens if you have an old os with a new postgresql install?
Will C
On 2/12/07, Bill Moseley <[EMAIL PROTECTED]> wrote:
On Mon, Feb 12, 2007 at 10:53:53AM -0500, Merlin Moncure wrote:
> On 2/12/07, Richard Broersma Jr <[EMAIL PROTECTED]> wrote:
> >> Can you describe in a little bit more detail about what you mean by
> >> 'Adjaceny LIst'?
> >
> >Adjaceny list is t
Dear All,
I'm still unsure about whether I am allowed to use PQexecParams to
execute a create view command with $n parameters; reading between the
lines of Peter Eisentraut's message I get the impression that this
isn't going to work. So:
- Can anyone offer a list of which commands are comp
On 12/02/07, Anton Melser <[EMAIL PROTECTED]> wrote:
> I think actually what he needs is what Peter suggested upthread, namely
> to weaken the context-restriction on the int-to-bool cast.
Indeed... Peter's suggestion seems to have solved all my problems. So
even though it probably shows just how
On Mon, 2007-02-12 at 15:16 -0500, HT NB wrote:
> Hi,
>
> How are you doing?
>
> First, I am testing if this email address is valid. It is the first
> time that I am using this account. I have a question about how to
> start write embedded SQL in C programming code. What are the basic
> requireme
I think actually what he needs is what Peter suggested upthread, namely
to weaken the context-restriction on the int-to-bool cast.
Indeed... Peter's suggestion seems to have solved all my problems. So
even though it probably shows just how embarrassingly bad my sql is...
update pg_cast set cast
Hi,
How are you doing?
First, I am testing if this email address is valid. It is the first time that I am using this account. I have a question about how to start write embedded SQL in C programming code. What are the basic requirements in the .pgc file to have the embedded SQL running.
This is my
My apologies if this is the wrong mailing list.
I've created a function that returns a list of all prime numbers in a
range.
eg: SELECT public.all_prime(190, 223);
191,193,197,199,211,223
I'd like to submit this the the contrib lib, but I could not find the
correct
email list. Use as you wish.
On Mon, 2007-02-12 at 09:09 +0100, Anton Melser wrote:
> In my searching I did turn up a comment (maybe from you even!) about
> how it wouldn't work (before at least). I guess my problem is that
> there is a body of sql that can't be changed, or at least the other
> devs aren't interested enough in
On Mon, Feb 12, 2007 at 10:53:53AM -0500, Merlin Moncure wrote:
> On 2/12/07, Richard Broersma Jr <[EMAIL PROTECTED]> wrote:
> >> Can you describe in a little bit more detail about what you mean by
> >> 'Adjaceny LIst'?
> >
> >Adjaceny list is the term used in the celko book to refer to a table tha
> I imagine the configuration was mangled somewhere down the line.
> Perhaps I need to reinstall Ubuntu, though it's not something I look
> forward to (I already tried uninstalling Postgres and wiping away all
> references to it prior to my last install).
>
> Thanks for taking a look!
>
> -
Brandon Aiken wrote:
You'll have to escape any quotation marks or your SQL will not parse
your strings correctly.
And you have to do this for all your data, not just XML. Otherwise the
first Mr. O'Malley you have a record for will break your application.
--
Richard Huxton
Archonet Ltd
On Mon, Feb 12, 2007 at 05:36:37PM +, Ian Harding wrote:
> You don't mention the ltree contrib module, have you looked at it? It
> can easily meet your requirements without having to reinvent anything.
> It may be what you're referring to as Nested Sets, I don't know. I
> use it and like it a
You'll have to escape any quotation marks or your SQL will not parse
your strings correctly.
--
Brandon Aiken
CS/IT Systems Engineer
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of deepak pal
Sent: Monday, February 12, 2007 4:07 AM
To: Postgre
deepak pal wrote:
hi,,
i have to insert whole xml file in database ,there is a text
field for that.but it shows error parse error where there are
attribute ..plz help me out.
I'm guessing you have a quoting problem. Try escaping the XML-data
before inserting it into the database, so
Thanks. Finally, I discovered one line not uncomment, stupid typos error.
Nicolas
2007/2/7, Nicolas Gignac <[EMAIL PROTECTED]>:
Hello,
I have installed Postgres 8.2 on a internal server having Windows Server
2003 (IIS 6) up and running.
- I have configure the hp_config file to: host
all
Hi Richard,
Thanks for your response.
Below is a console session (again, this is on Ubuntu). I attempt to
run the init script but can't start Postgres and don't see any error
messages in the console or output in the log directory.
I then switch to the 'postgres' user and can run pg_ctl to start
Hi,
I couldnt find this on google, the archives, or the manual. But with the
changes to what the autovacuum daemon logs, how can we verify it's doing its
thing? Is there a way to query the last time a table was vacuumed? But I
don't see that in the system catalog.
Thanks!
-
Saw this in the postgres 8.2.3 server log today:
2007-02-10 00:27:12 PST PANIC: XX001: corrupted item pointer: offset
= 0, size = 0
2007-02-10 00:27:12 PST LOCATION: PageIndexMultiDelete, bufpage.c:624
2007-02-10 00:27:56 PST LOG: 0: autovacuum process (PID 25471)
was terminated by si
folks
I can't install postgresql on winxp profesional
Installer fail ( creating cluster)
Installer with out cluster . ok
creating cluster on hand .fail
initdb
The files belonging to this database system will be
owned by user "postgres".
This user must also own the server process.
The
I use pgmanager from EMS to code, and have a fucntion that is always returning
a NULL value, when I run it in debug mode it works fine, I've traced the
problem down to this line
tag := substring(s, '<\s*?[^>]+\s*?>');
are there issues the regexps? I am using - PostgreSQL 8.0.3 on
i686-pc-lin
"Nicolas Gignac" <[EMAIL PROTECTED]> writes:
> I have installed Postgres 8.2 on a internal server having Windows Server
> 2003 (IIS 6) up and running.
> - I have configure the hp_config file to: host
> all 0.0.0.0./0
> md5
> - I have change the listening address to '*' i
hi,,
i have to insert whole xml file in database ,there is a text field
for that.but it shows error parse error where there are attribute ..plz
help me out.
On 2/12/07, Bill Moseley <[EMAIL PROTECTED]> wrote:
I'm looking for a little guidance in representing a file system --
well just the file and directory structure of a file system.
Often articles on representing a hierarchy discuss the advantages of
using Nested Sets (or nested intervals) it seem
On 2/12/07, Richard Broersma Jr <[EMAIL PROTECTED]> wrote:
> Can you describe in a little bit more detail about what you mean by
> 'Adjaceny LIst'?
Adjaceny list is the term used in the celko book to refer to a table that is
recurively related to
itself.
create table foo (
idinteger p
> Can you describe in a little bit more detail about what you mean by
> 'Adjaceny LIst'?
Adjaceny list is the term used in the celko book to refer to a table that is
recurively related to
itself.
create table foo (
idinteger primary key,
parentid integer references foo (id),
name
"Markus Wollny" <[EMAIL PROTECTED]> writes:
> I've just tried to initdb a fresh install of PostgreSQL 8.3.2 on Debian
> Etch (testing). My configure settings were
> ./configure --prefix=/opt/pgsql --datadir=/var/lib/pgsql/data/base
> --enable-locale --with-perl --enable-odbc --with-java
I don't t
"MG" <[EMAIL PROTECTED]> writes:
> Now we got the following error:
> pg_dump: [tar archiver] write error appending to tar archive (wrote =
> 28186, attempted 32767)
> There is enough space on the hard disk.
How big is the dump file? I seem to recall that tar format has a limit
on the size of indi
Shane Ambler <[EMAIL PROTECTED]> writes:
> If you look at the bool type you will find it calls a function called
> boolout(bool) which returns a cstring to return the data for the boolean
> - you could replace this with your own function that returns a 1 or 0
> instead of true or false. Similarl
On 2/11/07, Bill Moseley <[EMAIL PROTECTED]> wrote:
I'm looking for a little guidance in representing a file system --
well just the file and directory structure of a file system.
Often articles on representing a hierarchy discuss the advantages of
using Nested Sets (or nested intervals) it seem
Anton Melser wrote:
On 12/02/07, Tom Lane <[EMAIL PROTECTED]> wrote:
"Joshua D. Drake" <[EMAIL PROTECTED]> writes:
> Anton Melser wrote:
>> Is there any way
>> to force pg to accept 1 and 0 for boolean?
> postgres=# insert into bool_test values(1::boolean);
> INSERT 166968558 1
> postgres=# ins
Victor Adolfsson wrote:
Hi
My query is using a sequential scan and not an index scan even though
that I
have indexes defined on the foreign keys.
This cases my query to take a long long time (10750.687 ms) when it should
have been completed in less than 1 second.
Any ideas on what may be the c
Hi
My query is using a sequential scan and not an index scan even though that I
have indexes defined on the foreign keys.
This cases my query to take a long long time (10750.687 ms) when it should
have been completed in less than 1 second.
Any ideas on what may be the cause of this? I have done a
Hello!
I've just tried to initdb a fresh install of PostgreSQL 8.3.2 on Debian
Etch (testing). My configure settings were
./configure --prefix=/opt/pgsql --datadir=/var/lib/pgsql/data/base
--enable-locale --with-perl --enable-odbc --with-java
This is what happens:
[EMAIL PROTECTED]:~$ /opt/pgsq
On 2/11/07, Benjamin Arai <[EMAIL PROTECTED]> wrote:
Hi Edwin,
Which connection parameters effect system resources?
i remembered wrong. the connection parameters i was thinking of is here:
http://www.postgresql.org/docs/8.2/static/libpq-envars.html
however, looking more closely to the config
Hello,
we have a shell-script, which executes the pg_dump once a day. This script ran
already for about 6 months successfully.
Now we got the following error:
pg_dump: [tar archiver] write error appending to tar archive (wrote 28186,
attempted 32767)
There is enough space on the hard disk.
A
On Sun, Feb 11, 2007 at 08:54:56PM -0200, Cristiano Panvel wrote:
> Hi Friends,
>
> This is my first post in the list.
>
> I am not obtaining authentication my users of PostgreSQL in OpenLdap.
>
> 1) PostgreSQL was compiled with the support to ldap in a FreeBSD System.
> "option --with-ldap for
On Mon, 2007-02-12 at 08:17 +0100, dfx wrote:
> Dear Sirs,
>
> I am workink on Windows 2000 with PgAdmin III v. 1.6.2
>
> If I open an sql file created with UTF8 encoding the characters with accent
> are not reproduced correctly.
> If I open the same file with MS Word or JEdit or also PgAdmin III
On 12/02/07, Tom Lane <[EMAIL PROTECTED]> wrote:
"Joshua D. Drake" <[EMAIL PROTECTED]> writes:
> Anton Melser wrote:
>> Is there any way
>> to force pg to accept 1 and 0 for boolean?
> postgres=# insert into bool_test values(1::boolean);
> INSERT 166968558 1
> postgres=# insert into bool_test va
54 matches
Mail list logo
