hello
this is my first question.
I am new in postgres and using plsql.
i am making this (bellow)
i want to insert one copy of one record into the log table but if there is some
change into the original recor to update into this record two fields but i have
one rror
can you help me please?
What would be the faster way to convert a 7.4.x database into an 8.x
database? A dump of the database takes over 20 hours so we want to convert
the database without having to do a dump and resptore.
Hi Forum,
Is there a way to change the database access permissions for
different IP addresses without having to re-start PostgreSQL? I often
want to preclude all IP address but one from accessing the database.
Currently, I change the pg_hba.conf file and re-start the database but I would
Is there a way that I can find out the size of a bytea
record? I am storing images into bytea fields and I just want to know the size
of the image that it has been saved in the field
Thank you Tom. I will look at reindexing the database
---(end of broadcast)---
TIP 6: explain analyze is your friend
Could someone clarify the use of the –L option in
pg_restore? I have a pg_dump of a database (options –Ft –b) and I
want to restore most of the dump with the exception of one table into another
database. Can I do the following?:
1) restore the
tar file of the dump into a “list” fil
Hello Forum,
I would appreciate it if you could recommend settings to use
auto-vacuum in my version 7.4 database. I am uploading several thousands
records in the database at a rate of ~1 second per record (the data is
uploading from a different server). I have noticed that the performanc
Title: Eliminating start error message: "unary operator expected"
Hi Forum,
What should I correct in order to eliminate the following error message on start:
Executing /etc/rc.d/init.d/postgresql start ..
Starting postgresql service: -sh: [: ==: unary operator expected
[ OK ]
We installed
x27;
+ eval set X '-p 5432'
++ set X -p 5432
+ shift
+ '[' -n '' ']'
+ '[' -n '' ']'
+ '[' no = yes ']'
+ echo 'postmaster successfully started'
postmaster successfully started
+ exit 0
+ /usr/bin/pos
Title: Install files for version 7.4
Hello Forum,
Could someone please send me the link and the names of the files to install the version 7.4 in Windows 2000 server and XP Pro? I cannot discern the files that one is supposed to download.
Thanks in advance for your response.
Carlos Oliva
Dear Gurus :
First let me say hello from Buenos Aires, Argentina. I
took this emails addresses from internet ( page www.postgresql.org )
Now I will try to explain which is my problem ( excuse
my poor level of English, please ). I have a Java application that
;
select * from dw_bsc.proc_perspectives('R', 1, null, null, null, null,
null);
fetch all from "";
end;
inside the query gui tool provided by pgAdmin III
The connection into the java application was changed to
con.setAutoCommit(false);
I think I do not forget nothing else
Some h
a.m.
Para: Corradini, Carlos; pgsql-j...@postgresql.org;
pgsql-general@postgresql.org
CC: bo...@ejurka.com
Asunto: Re: [GENERAL] [JDBC] plpgsql function with RETURNS SETOF
refcursor in JAVA
On 12/11/2015 04:56 AM, Corradini, Carlos wrote:
> Mr. Adrian, here i transcribe the code of the function
diciembre de 2015 12:27 p.m.
Para: Corradini, Carlos; pgsql-j...@postgresql.org;
pgsql-general@postgresql.org
CC: bo...@ejurka.com
Asunto: Re: [GENERAL] [JDBC] plpgsql function with RETURNS SETOF
refcursor in JAVA
On 12/11/2015 07:10 AM, Corradini, Carlos wrote:
> Mr. Adrian, first let me say m
e been the most clear as my poor level of English could be
Many thanks for all and specially to the postgresql community list !!
-Mensaje original-
De: Kevin Grittner [mailto:kgri...@gmail.com]
Enviado el: viernes, 11 de diciembre de 2015 06:54 p.m.
Para: Corradini, Carlos
CC: Adria
w_bsc.proc_perspectives(character varying, integer,
character varying, character varying, character varying, integer, date) TO
usr_dw_bsc_sys_adm;
GRANT EXECUTE ON FUNCTION dw_bsc.proc_perspectives(character varying, integer,
character varying, character varying, character varying, integer,
Ok. I understand, to put there a pull request, I must to register into this
webpage ??
-Mensaje original-
De: Vladimir Sitnikov [mailto:sitnikov.vladi...@gmail.com]
Enviado el: lunes, 14 de diciembre de 2015 10:53 a.m.
Para: Corradini, Carlos
CC: Kevin Grittner; Adrian Klaver; List
I forgot one more thing ...
The return I made in the stored function is : RETURNS RECORD AS '
Excuse me for the forget ...
-Mensaje original-
De: Kevin Grittner [mailto:kgri...@gmail.com]
Enviado el: viernes, 11 de diciembre de 2015 06:54 p.m.
Para: Corradini, Carlos
CC: A
?
Try
Select * from people where person_id in (
Select person_ID from Items_for_people group by Person_id Having Count(*)
= (
Select count(*) from Items Where is_required = true))
Or something like that. That's the idea. Probe it and tell us.
(May be the sintaxis it's not corr
?
Try some thing like ths:
SELECT
companies.id,
companies.name,
companies.nickname,
(Select count(*) from videos where companies.id=videos.company_id and
videos.status= 'complete') num_videos
FROM companies
ORDER BY num_videos DESC
Hope this help
Carlo
evoke all on pg_views from new_user;
and another half dozen or so, but still the user is able to view
whatever it wants to view (not the data, of course --- if I do
"select * from some_table" then of course, I get access denied).
There must be solutions to this, ri
switches for pg_dump (pg_dump --help)
HTH,
Carlos
--
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
mand that you're running to start it
(without sudo, of course, since that'a already being run by root)
HTH,
Carlos
--
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
, and it is a very simple and direct consequence of
an as-unsound-as-it-gets db/table design.
Carlos
--
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAI
of *createdb*), regardless of what default encoding was
specified with initdb.
Oh, and BTW, welcome to version 8 of PostgreSQL ... The default
encoding for initdb is . Ta-d!!! Unicode !!!
Carlos
--
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
Michael Fuhr wrote:
On Fri, Sep 28, 2007 at 09:32:43PM -0400, Carlos Moreno wrote:
Oh, and BTW, welcome to version 8 of PostgreSQL ... The default
encoding for initdb is . Ta-d!!! Unicode !!!
No, it isn't. If you get UTF8 (formerly UNICODE) as a default then
it'
understand the difference between all storage
engine options and which does PostgreSQL use by default.
Thanks for any help...
-Carlos
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Just wondering how you guys feel about NoSQL and I just wanted to
share the following article...
http://www.linuxjournal.com/article/10770
Looking to read your feedback and / or opinions.
-Carlos
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
OK so I have read the docs and Google to try and find a way to add a
new column to an existing table. My problem is I need this new column
to be created 3rd rather than just dumping this new column to the end
of my table. I can't find anywhere how I can insert my new column as
the 3rd table column
On Wed, Oct 13, 2010 at 2:04 PM, Carlos Mennens
wrote:
> OK so I have read the docs and Google to try and find a way to add a
> new column to an existing table. My problem is I need this new column
> to be created 3rd rather than just dumping this new column to the end
> of my ta
I did an upgrade on my database server this past weekend and the
database fails to start. I checked /var/log/postgresql and found the
reason:
[r...@slave ~]# ps aux | grep postgres
root 5189 0.0 0.0 8128 956 pts/0S+ 12:28 0:00 grep postgres
[r...@slave ~]# /etc/rc.d/postgresql
On Mon, Nov 1, 2010 at 12:45 PM, Bill Moran wrote:
> I can't speak for Arch Linux' upgrade setup, but going from 8.4 -> 9.0
> requires that the data directory either be dumped/recreated, or ran
> through the new upgrade process (which (as yet) I have no experience
> with).
>
> If the Arch Linux st
On Mon, Nov 1, 2010 at 12:52 PM, Richard Broersma
wrote:
> oops: http://www.postgresql.org/docs/9.0/interactive/pgupgrade.html
Thanks for the URL. I will try this but I am confused how to proceed?
Can I attempt this with PostgreSQL 9.0.1-2 server installed and the
data is still 8.4 or do I need
On Mon, Nov 1, 2010 at 1:32 PM, Scott Marlowe wrote:
> you would do it with 9.0.x installed, and there should be a program in
> one of the 9.0 packages that has pg_upgrade in it.
So I have my 8.4.4-6 databases backed up. I don't know if I needed the
default 'postgres' database dumped but I did th
On Mon, Nov 1, 2010 at 2:00 PM, Bill Moran wrote:
> To clarify my earlier comments, if you're going to use pg_upgrade, you
> probably won't need to downgrade to 8.4. My comments about putting
> 8.4 back on would have be necessary if you were going to go the old
> dump/restore route.
I've already
On Mon, Nov 1, 2010 at 2:27 PM, Steve Crawford
wrote:
> I'm guessing you are missing an initdb. Move your old data directory
> somewhere else for now and do a new initdb so you can start up version 9.
When you say 'old data' can you be more specific as to the path and
possible files I need to mo
So I am still in the dark about the entire upgrade or step up process
from 8.4.4-6 to 9.0.1-2. I have my 4 databases all backed up which I
did when my server was 8.4.4-6 using the 'pg_dump' utility. That
worked fine. So after I backed up my databases, I then upgraded the
daemon to 9.0.1-2 and from
On Tue, Nov 2, 2010 at 10:53 AM, Steve Clark wrote:
> mv /var/lib/postgres/data /var/lib/postgres/data.old
Before I move or rename '/var/lib/postgres/data', what version of
PostgreSQL should I be at? 8.4 or 9.0?
> You will then have to do an initdb to create the basic 9.x databases.
> You can t
y database I create defaults to and I
also created two new schema's called 'fire' & 'ice' but from what I
have written above, obviously I don't have any understanding of how
they work.
I greatly appreciate any info and or help since I appear to be lost.
-Carlo
On Tue, Dec 14, 2010 at 7:17 PM, Joshua D. Drake wrote:
> You can cross query a schema but not a database.
>
> So you can create:
>
> create table fire.foo()
> create table ice.foo()
>
> And they are isolated from each other physically and logically but you
> can query them both:
>
> SELECT fire.*
I'm just wondering what programs you guys / girls are using PostgreSQL
for. So far I've installed PG 9 on my Debian Linux server and manually
created all my databases, schema's, and tables for my personal email /
address book. It's very basic and small but I was wondering if you
guys know of any pr
er of
---+---+---
carlos | Superuser | {}
postgres | Superuser, Create role, Create DB | {}
Now my question is about the section 'Member of' and how this is
commonly utilized by most PG administrators. Is this th
On Mon, Dec 20, 2010 at 10:41 AM, Adrian Klaver wrote:
> Roles = users/groups. In older versions there where users and groups, that has
> been consolidated into the concept of a role. If it makes it easier I use the
> concept of roles with login privileges as a users and roles without as groups.
On Mon, Dec 20, 2010 at 12:05 PM, Scott Marlowe wrote:
> Odd, mine does. Got a complete example of creating a role and not seeing it?
>
> Here's mine:
> smarlowe=# create role stans;
> CREATE ROLE
> smarlowe=# \dg
> List of roles
> Role name | Attributes | Member of
> ---+--
_US.UTF-8 | en_US.UTF-8 |
=c/postgres +
| | | | |
postgres=CTc/postgres
Thanks for helping me out!
-Carlos
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ld
like to see this grow into a full dedicated "official" web forums.
-Carlos Mennens
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
I've been reading the documentation and I'm trying to understand what
'GRANT' options make up a 'superuser' in PostgreSQL.
I've got my account which is 'carlos' and then I have an account
called 'jason'. Can someone please explai
I decided last night to rename my 'public' schema (Not sure of that's
a good / bad idea) since I'm still learning about how schema's work on
PostgreSQL. My question is:
1. If I have a constraint (specifically 'unique') on a specific table,
when I rename the public schema, does that impact my ''uni
On Thu, Jan 6, 2011 at 6:20 AM, Sim Zacks wrote:
> We are about to build a new database server, our plan is to use Debian.
>
> Is there documentation of recommended server configurations for Linux, such
> as kernel parameters, preferred file system, etc that work best with
> postgresql?
>
> I'm no
I was sitting down thinking the other day about when is it good to
generate a new database or just use an existing one. For example, lets
say my company name is called 'databasedummy.org' and I have a
database called 'dbdummy'. Now I need PostgreSQL to manage several
applications for my company:
-
Thanks for all the suggestions and everyone appears to agree that if
the applications don't need to share data, then I should split them up
into separate database and nothing more.
I appreciate your input and explanations as well.
-Carlos
--
Sent via pgsql-general mailing list (pgsql-ge
I've been searching the documentation and I've tried ALTER ROLE,
REVOKE, etc etc etc & can't seem to find anything that shows me how to
remove membership roles from a particular user / role. I've granted a
user name 'david' a member of 'finance' role but how do I remove the
role membership from 'da
I created a role named 'carlos' which is my current user account with
'superuser' grants but my question is when I look at 'postgres'
account, he has additional grants that I don't understand.
List of roles
On Fri, Feb 4, 2011 at 2:18 PM, David Johnston wrote:
> Not to be smart about it but you could just logon as carlos (or a different
> superuser you create for this purpose) and issue "Create Database xxx" and
> "Create Role xxx" statements and see whether they work.
On Fri, Feb 4, 2011 at 5:08 PM, Dmitriy Igrishin wrote:
> These all (SUPERUSER, CREATEDB, SUPERUSER) are role attributes.
> By performing ALTER ROLE postgres NOSUPERUSER it is possible to
> turn role with a superuser status into a role that just can create databases
> and manage roles (admin, but
Today on a new PostgreSQL 9.0.3 server I created a new user:
CREATE ROLE carlos LOGIN CREATEDB CREATEROLE;
CREATE ROLE
I then set a password and comment on the user:
ALTER ROLE carlos WITH PASSWORD 'letmein';
ALTER ROLE
COMMENT ON ROLE carlos IS 'Database Administrator';
C
implicit index
"employees_pkey" for table "employees"
NOTICE: CREATE TABLE / UNIQUE will create implicit index
"employees_email_key" for table "employees"
CREATE TABLE
-Carlos
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
I'm trying to figure out how I can have users in the office connect
their Microsoft Office 2007 clients to our company database server
running PostgreSQL 8.4.7. I've configured PostgreSQL to accept
incoming connections and allow users to login however I read that I
need to have each client install
On Tue, Feb 15, 2011 at 12:46 PM, A.M. wrote:
> I googled "connect excel postgresql" and found this:
>
> http://port25.technet.com/videos/research/excelopendbprimer.pdf
>
> which seems to take one through all the steps.
I have been using that actual .PDF as a guide and I guess it's
different on O
I've only been using PostgreSQL since Oct 2010 and it's my first
experience with SQL or any ORDBMS. I've searched on the web and been
creating my own database users, databases, tables from scratch which
has been interesting to say the least but now I would like to know if
this is possible in SQL or
On Wed, Apr 6, 2011 at 11:20 AM, Andrew Sullivan wrote:
> Why do you have the age stored at all? When you SELECT from the table
> and want someone's age, just do
>
> SELECT [. . .], extract('years' from age(CURRENT_TIMESTAMP,dob)) as age
> . . . FROM users . . .
>
> By and large, it'
On Wed, Apr 6, 2011 at 11:24 AM, JC de Villa wrote:
> Theres also the age() function
>
> SELECT age(dob);
>
> Should give you
>
> age
> -
> 31 years 5 mons 17 days
>
> If you want to be really exact about it. :)
That worked awesome too!
ide=# SELECT age(dob
or missing here? I can't
disable SSL per DoD requirements sadly.
-Carlos
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Fri, Apr 8, 2011 at 1:15 PM, Diego Schulz wrote:
> Hi,
> When linking to the certificate and key you should specify the full path.
> ln -s /etc/ssl/certs/db1_ssl.crt /full/path/to/db1_ssl.crt
> ln -s /etc/ssl/private/db1_ssl.key /full/path/to/db1_ssl.key
Thanks for the quick reply Diego
On Fri, Apr 8, 2011 at 2:01 PM, Adrian Klaver wrote:
> Per here:
> http://www.postgresql.org/docs/8.4/static/ssl-tcp.html
> File Contents Effect
> server.crt server certificate requested by client
> server.key server private key proves server certificate sent by
> own
I've searched and really can't find a definitive example or someone
renaming a constraint. I renamed a table yesterday and noticed that
the constraint name was still named the old table name:
inkpress=# ALTER TABLE accounts RENAME TO fashion;
ALTER TABLE
inkpress=# \d fashion
Table "pu
On Fri, Apr 8, 2011 at 8:35 PM, Tom Lane wrote:
> I believe you can rename the underlying indexes and the constraints will
> follow them. (This works in HEAD anyway, not sure how far back.)
I'm sorry but I don't understand what that means or how to relate that
to a SQL command to rename the cons
On Fri, Apr 8, 2011 at 8:35 PM, Tom Lane wrote:
> I believe you can rename the underlying indexes and the constraints will
> follow them. (This works in HEAD anyway, not sure how far back.)
Below is my table:
inkpress=# \d marketing
Table "public.marketing"
Column | Type
On Sat, Apr 9, 2011 at 12:58 PM, Tom Lane wrote:
> ALTER INDEX accounts_pkey RENAME TO whatever
>
> On very old versions of PG you may have to spell that "ALTER TABLE"
> instead of "ALTER INDEX", but it's the same thing either way.
Thank you so much for clearing that up for me Tom! I just couldn'
Hi everyone, I wonder if you could help me with a procedure that I would
like to perform in postgresql.
I have an insert query like this:
INSERT INTO products (product_id, description, price, qty, ...) values
('01', 'some description', 10.15, 5, ...)
then if there is no problem, perform another
2014-06-05 9:32 GMT-06:00 Carlos Carcamo :
> Hi everyone, I wonder if you could help me with a procedure that I would
> like to perform in postgresql.
>
> I have an insert query like this:
>
> INSERT INTO products (product_id, description, price, qty, ...) values
> (&#
-06-05 10:14 GMT-06:00 Seref Arikan :
> Sorry, I meant: "calling a stored procedure you'll write in postgres from
> php"
>
>
> On Thu, Jun 5, 2014 at 5:13 PM, Seref Arikan
> wrote:
>
>> Hi Carlos,
>> When you say procedures, do you mean calling
Just a little, I will read it again, thanks for your help.
2014-06-05 10:39 GMT-06:00 David G Johnston :
>
> Have you read this chapter of the documentation?
>
> http://www.postgresql.org/docs/9.3/interactive/plpgsql.html
>
>
> Carlos Carcamo wrote
> > What I
Hello list, I need some help with this error:
...
pg_dump: saving encoding = UTF8
pg_dump: saving standard_conforming_strings = on
pg_dump: [archiver] -C and -c are incompatible options
pg_dump: *** aborted because of error
Process returned exit code 1.
I get this error when i'm trying to create
Hello list, hope you're well.
I need some help with postgres.
I have two triggers that are executed after insert, update and delete.
One trigger is with plpgsql language and the other one is with
pl/python, the first one just update some tables and last one calls a
*.sh that is executed to perfor
2014-12-04 16:46 GMT-06:00 David G Johnston :
> Carlos Carcamo wrote
>> I read about order of execution of triggers, is supposed that postgres
>> executes triggers in alphabetical order, so I called the plpgsql
>> a_trigger and the second one b_trigger (as an example), but
2014-12-04 17:31 GMT-06:00 Adrian Klaver :
> On 12/04/2014 03:11 PM, Carlos Carcamo wrote:
>>
>> 2014-12-04 16:46 GMT-06:00 David G Johnston :
>>>
>>> Carlos Carcamo wrote
>>>>
>>>> I read about oGlenrder of execution of triggers, is supp
onal values. Sadly unless
you create one yourself, I don't think there's one publicly available
that meets our expectations.
--
Carlos Mennens
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ction pg_file_rename(text,text)
owner of function pg_file_rename(text,text,text)
owner of function pg_file_write(text,text,boolean)
owner of extension adminpack
--
Carlos Mennens
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http:
___**
>
> See
> http://www.peak6.com/email_**disclaimer/<http://www.peak6.com/email_disclaimer/>for
> terms and conditions related to this email
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/**mailpref/pgsql-general<http://www.postgresql.org/mailpref/pgsql-general>
>
--
Carlos Mennens
I can't understand what is going on with my PostgreSQL server. For
some reason after I GRANT my role 'carlos' to the 'dba' group role, I
lose the ability to login. I've reset the password over and over for
'carlos' and even reversing the grant doesn'
I'm doing this all in psql.
Example:
CREATE ROLE carlos LOGIN CREATEDB CREATE ROLE REPLICATION;
Then set password \password carlos
Now I create the ROLE:
CREATE ROLE dba NOLOGIN;
So now I have two roles:
-carlos = user role
-dba = group role
I can login just fine as 'carlos&#x
I dropped both roles (Carlos & DBA) from the database and I will show
you exactly what I'm doing:
postgres=# \du
List of roles
Role name | Attributes |
What am I missing here?
postgres=> SELECT current_user;
current_user
--
carlos
(1 row)
postgres=> CREATE DATABASE carlosdb;
ERROR: permission denied to create database
postgres=> \du
List of roles
http://www.postgresql.org/message-id/440d446e.7040...@cybertec.at
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Gauthier, Dave
Sent: Wednesday, July 10, 2013 3:49 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] How to implement a value
Also this:
http://www.postgresql.org/docs/9.2/static/textsearch-configuration.html
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Gauthier, Dave
Sent: Wednesday, July 10, 2013 3:49 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] How to
according to what you write pentaho best fits your needs
On Tue, Aug 27, 2013 at 5:52 PM, Pavel Stehule wrote:
>
> Dne 28. 8. 2013 0:05 "Jerry Sievers" napsal(a):
>
> >
> > Alban Hertroys writes:
> >
> > > On Aug 27, 2013, at 19:07, Paul Jungwirth
> wrote:
> > >
> > >> Hi Alban,
> > >>
> > >>
Checkout the Saiku, the future of Open Source Interactive OLAP(
http://analytical-labs.com )
On Tue, Aug 27, 2013 at 8:34 PM, Carlos Saritama wrote:
> according to what you write pentaho best fits your needs
>
>
> On Tue, Aug 27, 2013 at 5:52 PM, Pavel Stehule wrote:
>
>>
Is there a way to create a database or a table of a database in its own
folder? We are looking for ways to backup the sytem files of the database
to tape and one to exclude some tables from this backup. We can selectively
backup folders of the file system so we figure that if we can create a
If I were to upgrade the database version, would I need to dump and restore
all the data?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
altech.com...
> In response to "Carlos Oliva" :
>
>> If I were to upgrade the database version, would I need to dump and
>> restore
>> all the data?
>
> If you upgrade patch releases (i.e. from 8.3.4 -> 8.3.5) then usually no,
> but see the release note
rowne" wrote in message
news:87prdlgurv@dba2.int.libertyrms.com...
> "Carlos Oliva" writes:
>> Would the backup be unrecoverable if I shutdown the databse first?
>
> If the backup includes pg_xlog and pg_clog, as well as all of the
> database metadata files, the
Would I need to upgrade the entire cluster or can I just upgrade database
wise?
""Grzegorz Jaskiewicz"" wrote in message
news:2f4958ff0906030845t526db574q464c17072fadd...@mail.gmail.com...
> if you upgrade to different major version, yes. If between minor
> releases (say 8.1.4->8.1.5) than no, w
the
database access for parts of the application until we complete the migration
to the new version.
""Grzegorz Jaskiewicz"" wrote in message
news:2f4958ff0906031157v32fb9810j9476fd950e494...@mail.gmail.com...
> On Wed, Jun 3, 2009 at 5:11 PM, Carlos Oliva wrote:
>>
""Grzegorz Jaskiewicz"" wrote in message
news:2f4958ff0906031214k3dfaa4b2mae5733d7345f7...@mail.gmail.com...
On Wed, Jun 3, 2009 at 8:03 PM, Carlos Oliva wrote:
> Woudl it be possible to keep the current postgresql version running in a
> different port, install a new
altech.com...
> In response to Grzegorz Jaskiewicz :
>
>> On Wed, Jun 3, 2009 at 8:14 PM, Bill Moran
>> wrote:
>> > In response to "Carlos Oliva" :
>> >
>> >> Woudl it be possible to keep the current postgresql version running in
>> &g
t;Grzegorz Jaskiewicz"" wrote in message
news:2f4958ff0906031217h2a0bfe0t674f266d4397e...@mail.gmail.com...
On Wed, Jun 3, 2009 at 8:14 PM, Bill Moran wrote:
> In response to "Carlos Oliva" :
>
>> Woudl it be possible to keep the current postgresql version running in a
&
ot; wrote in message
news:20090603161817.131e706e.wmo...@potentialtech.com...
> In response to "Carlos Oliva" :
>
>> Can the synchronization with Slony run while the old database is still
>> being
>> updated daily? I am wondering if we can just let Slony run u
b5a38b7ka1a4b1f3a4ce...@mail.gmail.com...
pg_xlog and clog is something that is used during operation, and for
point in time recovery.
It doesn't go to database dump at all, not needed.
On Thu, Jun 4, 2009 at 12:32 PM, Carlos Oliva wrote:
> Thank you for your response Grzegorx. It is helping us a gr
7f...@mail.gmail.com...
On Thu, Jun 4, 2009 at 1:07 PM, Carlos Oliva wrote:
> Thanks again Grzgorz for your expedicious reply. Would anything else
> change
> in the database for a table once it ceases to be updated? We have several
> tables for which a number of records is inserted and nev
1 - 100 of 415 matches
Mail list logo
