Re: [GENERAL] Database migration to RDS issues permissions

pg_rest OPTIONS ( password 'X', "user" 'user' ); Regards. ____ De: Adrian Klaver Enviado: sábado, 19 de noviembre de 2016 23:49 Para: Fran ...; pgsql-general@postgresql.org; t...@sss.pgh.pa.us Asunto: Re: [GENERAL] Database m

Re: [GENERAL] Database migration to RDS issues permissions

chiver (db)] could not execute query: ERROR: index "id_e" does not exist Command was: DROP INDEX public.id_e; I run the dump from origin with postgres user. De: Adrian Klaver Enviado: sábado, 19 de noviembre de 2016 18:41 Para: Fran ...; pgsql-gener

Re: [GENERAL] Database migration to RDS issues permissions

public.cksum4(text) OWNER TO postgres; @Adrian Klaver<mailto:adrian.kla...@aklaver.com> what others permissions do you suggest? Origin and target are the same version of course. PostgreSQL 9.4.1 Thanks in advance. ____ De: Adrian Klaver Enviado: sábado, 19 de nov

Re: [GENERAL] Database migration to RDS issues permissions

egclass); Thanks in advance. De: Adrian Klaver Enviado: sábado, 19 de noviembre de 2016 15:41 Para: Fran ...; pgsql-general@postgresql.org Asunto: Re: [GENERAL] Database migration to RDS issues permissions On 11/19/2016 05:21 AM, Fran ... wrote: > Hi, &g

[GENERAL] Database migration to RDS issues permissions

Hi, I have to migrate a production database to RDS. This is the size and info: database | owneruser | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =Tc/owneruser+| 32 GB | pg_default | Origin database: 1 database 1 owneruser with superuser permission Backup archived size is

Re: [GENERAL] Role and grants

| {} Regards. De: Adrian Klaver Enviado: miércoles, 9 de noviembre de 2016 21:02 Para: Fran ...; pgsql-general@postgresql.org Asunto: Re: [GENERAL] Role and grants On 11/09/2016 11:05 AM, Fran ... wrote: > Hi, > > > I am a new user with Postgr

[GENERAL] Role and grants

Hi, I am a new user with PostgreSQL, I came from MySQL and I am experiencing some issues with roles and privileges. I have created a DB,user and grant privilege on this DB to this user. How could I check what is the privileges/permissions for this user? Transcript: postgres=# create datab

Re: [GENERAL] Error Codes?

> Rob Arnold wrote: > > > Look at $db->errstr That has the text version of the error code. > > > > --rob Yes, but I want to know about the codes, not the text. If the codes exist, they are easier to work with than the text. -Fran -

[GENERAL] Error Codes?

o insert too many columns into a row, and a 1 if the connection fails. What's the scoop, and if error codes really do exist, is there a list of such codes? Thanks, Fran ---(end of broadcast)--- TIP 5: Have you checked our extensi

[GENERAL] replication?

mething if that will work. I looked through the docs but didn't see anything about replication in the Administrator manual, where I assume it'd be discussed. I did see a vague reference to a replication toolkit in the release notes, is this what I'm looking for? Thanks, Fran --

Re: [GENERAL] do i need a view or procedure?

particular host, we then use this table to say which of those they already have installed and remove those from the result set. So, it does work very nicely for that. Thanks for the input, if nothing else, it gets the brain thinking about it in different ways. Thanks, Fran ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl

[GENERAL] do i need a view or procedure?

ng out how to even approach this, so any feedback at all would be greatly appreciated! Thanks for reading this far :-) Sincerely, Fran ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html

Re: [GENERAL] "trigger"ing a procedure every X minutes

7;d like to try it someday, when I know a lot more about Pg. My current project has an ever-growing number of cron jobs (up to 6 now) and was just thinking about various ways to tidy it up. Thanks for the info, Fran > Fran Fabrizio <[EMAIL PROTECTED]> writes: > > Is the preferred

[GENERAL] Calling external programs

all a procedure written in say PLPERL? Is PLPERL capable of calling external programs or better yet forming the mail and calling sendmail itself? Thanks, Fran ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/

Re: [GENERAL] Trigger only firing once

x27;), upper('INFO'), '1 medssld(s) running.', '20010513 00:00:00'); 2001-05-14 12:05:47 DEBUG: ProcessQuery 2001-05-14 12:05:47 DEBUG: query: SELECT now() 2001-05-14 12:05:47 DEBUG: query: SELECT * from sites s where s.fqdn = $1 2001-05-14 12:05:47 DEBUG: query: SE

[GENERAL] Trigger only firing once

procedure from a text file of sql which hasn't changed in weeks. It worked perfectly in postgresql 7.0, but now that I think about it, I can't confirm it ever working correctly in 7.1 since I upgraded earlier in the week. Thanks, Fran ---(end of

[GENERAL] formatting a date

I'm looking all over the place in the Pg docs and Momjian book and having no luck finding any functions that would turn a timestamp such as 2001-05-08 23:59:59-04 into May 8, 2001. (i.e. do what date_format() was doing for me in MySQL.) Is there equivalent functionality in Pg? Thanks,

[GENERAL] Trigger only firing once

the trigger once per connection. Thanks, Fran ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [GENERAL] select off of a view going slowly

ime and learn about views, and relational databases in general, more deeply. Then maybe I can help out around here some more! =) Thanks, Fran monitoring=# select * from error_log; count | site_id | host_id ---+-+- 8 | 34 | 88 8 | 34 | 110 (2 rows) The q

[GENERAL] Re: Stranger than fiction - EXPLAIN results

imestamp | Indices: status_5_column_index, status_host_id_key, status_site_id_key monitoring=# So it's puzzling me why it's still doing a Seq. Scan vs. an Index Scan. Any ideas? Thanks, Fran ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[GENERAL] DBI/AutoCommit/Postgres

chine are: Pentium III 733Mhz, 512 megs memory, 7 gigs free on the partition. Seems like I should be getting a lot more horsepower. I really need to speed this up somehow. Does anyone see anything in the trigger or otherwise that would cause this to be so slow? Thank you very much, Fran ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [GENERAL] installing DBD::Pg without installing postgres

having MySQL locally, but DBI::Proxy may be an even cleaner solution. Thanks everyone for the dialogue, it has been very useful! -Fran ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [GENERAL] installing DBD::Pg without installing postgres

Maybe my hopes are misguided. =) Thanks, Fran ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[GENERAL] installing DBD::Pg without installing postgres

27;m turning up appears geared towards the assumption that you also want postgres installed locally. Am I looking in the wrong places? Thanks, Fran ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/us

[GENERAL] getting the currval of a sequence

Hi all, I need to do the equivalent of: select my_sequence.CURRVAL from Sys.dual; so I'm guessing its: select currvar('my_sequence') from ???; Can anyone fill in the ???? Thanks! -Fran

[GENERAL] designating a column as primary key after creation

Why does postgres choke on the following: alter table mytable add constraint mycolumn_pk primary key(mycolumn); is this possible in a postgres database? if not, what's an easy workaround, i really need to have this column as primary key. Thanks! -Fran